From ba3afc88d2b81fc609cda8504ee7b54c54b379d7 Mon Sep 17 00:00:00 2001 From: Robert Haas <rhaas@postgresql.org> Date: Wed, 19 Jan 2011 21:21:33 -0500 Subject: [PATCH] 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 4f561f6fb7..de4e1e027f 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 26bc224384..1e29852b40 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -1516,7 +1516,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> @@ -1530,7 +1530,8 @@ SELECT <replaceable>select_list</replaceable> FROM <replaceable>table_expression <para> <literal>WITH</> provides a way to write subqueries for use in a larger - <literal>SELECT</> query. The subqueries can be thought of as defining + <literal>SELECT</> 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: -- 2.40.0