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