diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-12-18 16:22:31 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-12-18 16:22:31 +0000 |
| commit | 5ac3cd0f0c9ad2886169c18a4ca3577f93cffc88 (patch) | |
| tree | 0a4e34a56edc0973c3f00e1b46b433c8ff7f9491 /doc/src | |
| parent | 4060456291693431d57ca64adf3973ea1dba81cc (diff) | |
Include example of Postgres' extended query syntax which allow one to omit
the FROM clause. e.g. "SELECT table.*".
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/select.sgml | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index a1b0ec4fe33..315447a0bea 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -498,6 +498,27 @@ SELECT actors.name <date>1998-09-24</date> </refsect2info> <title> + <acronym>Extensions</acronym> + </title> + + <para> +<productname>Postgres</productname> allows one to omit +the <command>FROM</command> clause from a query. This feature +was retained from the original PostQuel query language: + <programlisting> +SELECT distributors.* WHERE name = 'Westwood'; + + did|name + ---+---------------- + 108|Westward + </programlisting> + </para> + + <refsect2 id="R2-SQL-SELECT-5"> + <refsect2info> + <date>1998-09-24</date> + </refsect2info> + <title> <acronym>SQL92</acronym> </title> <para> |
