postgres.rst
changeset 2422 242e08fa2c73
parent 2421 07304e8a9820
child 2436 41f79c1242b2
--- 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;
+