On tis, 2010-12-28 at 09:31 -0800, David Fetter wrote: > Common Table Expression, or CTE for short, is the standard > terminology, and I don't just mean SQL:2008. It's standard in DB2, > Drizzle, Firebird, HSQLDB, Informix, Microsoft SQL Server, Oracle, and > Sybase SQL Anywhere, at a minimum. > > "WITH query" is a pure PostgreSQL invention, and not a super helpful > one to the vast majority of users.
The phrase "common table expression" does not appear anywhere in the SQL standard. The standard uses the grammar symbol <with clause>. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
