| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | David Fetter <david(at)fetter(dot)org> |
| Cc: | Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: "writable CTEs" |
| Date: | 2010-12-28 20:07:14 |
| Message-ID: | 1293566834.21318.3.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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>.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-12-28 20:18:43 | Re: the number of file descriptors when using POSIX semaphore |
| Previous Message | Peter Eisentraut | 2010-12-28 20:04:38 | Re: "writable CTEs" |