Commit92f7eeb

committed

Document that WITH queries are also called Common Table Expressions.

Peter Geoghegan, reviewed by Stephen Frost

1 parent357faea commit92f7eebCopy full SHA for 92f7eeb

File tree

+12

-2

lines changed

+12

-2

lines changed

Lines changed: 9 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -98,6 +98,15 @@`
`98`	`98`	`</listitem>`
`99`	`99`	`</varlistentry>`
`100`	`100`
	`101`	`+ <varlistentry>`
	`102`	`+ <term><acronym>CTE</acronym></term>`
	`103`	`+ <listitem>`
	`104`	`+ <para>`
	`105`	`+ <link linkend="queries-with">Common Table Expression</link>`
	`106`	`+ </para>`
	`107`	`+ </listitem>`
	`108`	`+ </varlistentry>`
	`109`	`+`
`101`	`110`	`<varlistentry>`
`102`	`111`	`<term><acronym>CVE</acronym></term>`
`103`	`112`	`<listitem>`

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1525,7 +1525,7 @@ SELECT <replaceable>select_list</replaceable> FROM <replaceable>table_expression`
`1525`	`1525`
`1526`	`1526`
`1527`	`1527`	`<sect1 id="queries-with">`
`1528`		`- <title><literal>WITH</literal> Queries</title>`
	`1528`	`+ <title><literal>WITH</literal> Queries (Common Table Expressions)</title>`
`1529`	`1529`
`1530`	`1530`	`<indexterm zone="queries-with">`
`1531`	`1531`	`<primary>WITH</primary>`
`@@ -1539,7 +1539,8 @@ SELECT <replaceable>select_list</replaceable> FROM <replaceable>table_expression`
`1539`	`1539`
`1540`	`1540`	`<para>`
`1541`	`1541`	`<literal>WITH</> provides a way to write subqueries for use in a larger`
`1542`		`- query. The subqueries can be thought of as defining`
	`1542`	`+ query. The subqueries, which are often referred to as Common Table`
	`1543`	`+ Expressions or <acronym>CTE</acronym>s, can be thought of as defining`
`1543`	`1544`	`temporary tables that exist just for this query. One use of this feature`
`1544`	`1545`	`is to break down complicated queries into simpler parts. An example is:`
`1545`	`1546`

Comments

(0)