# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1592307846 -10800
# Node ID 07304e8a9820af3c923bd914e15152b8828cd01e
# Parent  da418d28831e457224f81ae44ef53bce7e359639
Temporary constant table (with).

diff -r da418d28831e -r 07304e8a9820 postgres.rst
--- a/postgres.rst	Tue Jun 16 14:37:50 2020 +0300
+++ b/postgres.rst	Tue Jun 16 14:44:06 2020 +0300
@@ -639,7 +639,13 @@
   SELECT num, str FROM (
     VALUES (1, 'a'), (2, 'b'), (3, 'c')) AS tbl(num, str);
 
+  WITH tbl(num, str) AS (VALUES (1, 'a'), (2, 'b'), (3, 'c'))
+  SELECT num, str FROM tbl;
+
 To generate table::
 
   SELECT val FROM generate_series(1, 10) val;
 
+  WITH t AS (SELECT val FROM generate_series(1, 10) val)
+  SELECT * FROM t;
+