On 28 December 2010 20:07, Peter Eisentraut <pete...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
