diff options
| -rw-r--r-- | doc/src/sgml/acronyms.sgml | 9 | ||||
| -rw-r--r-- | 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 64efd323955..0e2b1bcc35d 100644 --- a/doc/src/sgml/acronyms.sgml +++ b/doc/src/sgml/acronyms.sgml @@ -99,6 +99,15 @@ </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> <para> diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index 21a3a8d1a6c..e54de756dc5 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -1526,7 +1526,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> @@ -1540,7 +1540,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: |