generate table.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 16 Jun 2020 16:42:34 +0300
changeset 2422 242e08fa2c73
parent 2421 07304e8a9820
child 2423 6a4fd5ccb340
generate table.
postgres.rst
--- a/postgres.rst	Tue Jun 16 14:44:06 2020 +0300
+++ b/postgres.rst	Tue Jun 16 16:42:34 2020 +0300
@@ -649,3 +649,9 @@
   WITH t AS (SELECT val FROM generate_series(1, 10) val)
   SELECT * FROM t;
 
+  WITH
+    seq1(num) AS (VALUES (1), (2), (3)),
+    seq2(str) AS (VALUES ('a'), ('b'), ('c'))
+  SELECT * FROM seq1
+  CROSS JOIN seq2;
+