File: ex75.sql

package info (click to toggle)
pgformatter 5.9-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 7,964 kB
  • sloc: sql: 186,493; perl: 5,694; makefile: 2; sh: 1
file content (4 lines) | stat: -rw-r--r-- 156 bytes parent folder | download 
1
2
3
4
 
WITH example AS (SELECT a, b FROM tablename),
example2 AS (SELECT COALESCE(a, 1) AS a, b FROM example)
INSERT INTO example3 (a, b)
SELECT a, b FROM example