postgres.git / summary / log / commit / refs
commit 92f7eebbbd6554f0414ab869abd8733cef751249
Author: Robert Haas <rhaas@postgresql.org>
Date: Thu Jan 20 02:15:45 2011 +0000
First released in: 9.1.0, 8.4.7, 9.0.3
Document that WITH queries are also called Common Table Expressions.
Peter Geoghegan, reviewed by Stephen Frost
doc/src/sgml/acronyms.sgml | 9 +++++++++
doc/src/sgml/queries.sgml | 5 +++--
2 files changed, 12 insertions(+), 2 deletions(-)
diff --git a/doc/src/sgml/acronyms.sgml b/doc/src/sgml/acronyms.sgml
index 23ab3b410bd..5dad0db1378 100644
--- a/doc/src/sgml/acronyms.sgml
+++ b/doc/src/sgml/acronyms.sgml
@@ -98,6 +98,15 @@
</listitem>
</varlistentry>
+ <varlistentry>
+ <term><acronym>CTE</acronym></term>
+ <listitem>
+ <para>
+ <link linkend="queries-with">Common Table Expression</link>
+ </para>
+ </listitem>
+ </varlistentry>
+
<varlistentry>
<term><acronym>CVE</acronym></term>
<listitem>
diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml
index f6e081ea732..693fce531f4 100644
--- a/doc/src/sgml/queries.sgml
+++ b/doc/src/sgml/queries.sgml
@@ -1525,7 +1525,7 @@ SELECT <replaceable>select_list</replaceable> FROM <replaceable>table_expression
<sect1 id="queries-with">
- <title><literal>WITH</literal> Queries</title>
+ <title><literal>WITH</literal> Queries (Common Table Expressions)</title>
<indexterm zone="queries-with">
<primary>WITH</primary>
@@ -1539,7 +1539,8 @@ SELECT <replaceable>select_list</replaceable> FROM <replaceable>table_expression
<para>
<literal>WITH</> provides a way to write subqueries for use in a larger
- query. The subqueries can be thought of as defining
+ query. The subqueries, which are often referred to as Common Table
+ Expressions or <acronym>CTE</acronym>s, can be thought of as defining
temporary tables that exist just for this query. One use of this feature
is to break down complicated queries into simpler parts. An example is:
[parent: 357faea82e93]