diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/queries.sgml | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index d7b0d731b9d..c32c8576518 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -1609,7 +1609,16 @@ SELECT 3, 'three'; <literal>VALUES</> table. The column names are not specified by the SQL standard and different database systems do it differently, so it's usually better to override the default names with a table alias - list. + list, like this: +<programlisting> +=> SELECT * FROM (VALUES (1, 'one'), (2, 'two'), (3, 'three')) AS t (num,letter); + num | letter +-----+-------- + 1 | one + 2 | two + 3 | three +(3 rows) +</programlisting> </para> <para> |