diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2012-04-14 09:08:08 +0300 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2012-04-14 09:08:08 +0300 |
| commit | aacc50d1758632550bebc4911857b323d65f0996 (patch) | |
| tree | 969688015dae875354c3b33eb21c622b4f4c4f99 | |
| parent | f3a3aac8452c0af53d510b4f042ff5ee939a1799 (diff) | |
| download | postgresql-aacc50d1758632550bebc4911857b323d65f0996.tar.gz postgresql-aacc50d1758632550bebc4911857b323d65f0996.zip | |
Document that VALUES can be used in WITH
| -rw-r--r-- | doc/src/sgml/ref/select.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 01c01046249..7e989242587 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -58,7 +58,7 @@ SELECT [ ALL | DISTINCT [ ON ( <replaceable class="parameter">expression</replac <phrase>and <replaceable class="parameter">with_query</replaceable> is:</phrase> - <replaceable class="parameter">with_query_name</replaceable> [ ( <replaceable class="parameter">column_name</replaceable> [, ...] ) ] AS ( <replaceable class="parameter">select</replaceable> | <replaceable class="parameter">insert</replaceable> | <replaceable class="parameter">update</replaceable> | <replaceable class="parameter">delete</replaceable> ) + <replaceable class="parameter">with_query_name</replaceable> [ ( <replaceable class="parameter">column_name</replaceable> [, ...] ) ] AS ( <replaceable class="parameter">select</replaceable> | <replaceable class="parameter">values</replaceable> | <replaceable class="parameter">insert</replaceable> | <replaceable class="parameter">update</replaceable> | <replaceable class="parameter">delete</replaceable> ) TABLE [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ] </synopsis> @@ -208,7 +208,7 @@ TABLE [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ] subqueries that can be referenced by name in the primary query. The subqueries effectively act as temporary tables or views for the duration of the primary query. - Each subquery can be a <command>SELECT</command>, + Each subquery can be a <command>SELECT</command>, <command>VALUES</command>, <command>INSERT</command>, <command>UPDATE</command> or <command>DELETE</command> statement. When writing a data-modifying statement (<command>INSERT</command>, |