summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorThomas G. Lockhart <lockhart@fourpalms.org>1998-12-18 16:22:31 +0000
committerThomas G. Lockhart <lockhart@fourpalms.org>1998-12-18 16:22:31 +0000
commit5ac3cd0f0c9ad2886169c18a4ca3577f93cffc88 (patch)
tree0a4e34a56edc0973c3f00e1b46b433c8ff7f9491 /doc/src
parent4060456291693431d57ca64adf3973ea1dba81cc (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.sgml21
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>