Re: "writable CTEs" - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: "writable CTEs"
Date
Msg-id AANLkTik84hRR-Rc0dej7pU4VrfcY=Fdyx-=AaPBejd7W@mail.gmail.com
Whole thread Raw
In response to Re: "writable CTEs"  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: "writable CTEs"
List pgsql-hackers
On 28 December 2010 20:07, Peter Eisentraut <peter_e@gmx.net> wrote:
> The phrase "common table expression" does not appear anywhere in the SQL
> standard.  The standard uses the grammar symbol <with clause>.

I think we're losing sight of the issue a bit here.

No one is proposing that we call WITH queries common table
expressions. As I think we all agree, the term "WITH query" and
"common table expression" are not synonymous. A WITH query is
comprised of one or more common table expressions, plus a conventional
SELECT query.

All that I'm asking is that we /specify/ that the "subqueries" already
mentioned in the docs are common table expressions. This terminology
is less confusing and ambiguous, is demonstrably already in widespread
use, and will probably lay the groundwork for whatever name we choose
for wCTEs.

I think that it makes sense to change the title of the relevant
section from "WITH Queries" to "WITH Queries (Common Table
Expressions)" because CTEs are the defining characteristic of WITH
queries, and, as I've said, the term "common table expression" has
mindshare in a way that "WITH query" clearly doesn't.

--
Regards,
Peter Geoghegan


pgsql-hackers by date:

Previous
From: David Wilson
Date:
Subject: Re: pg_dump --split patch
Next
From: Joel Jacobson
Date:
Subject: Re: pg_dump --split patch