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

From Peter Eisentraut
Subject Re: "writable CTEs"
Date
Msg-id 1293566834.21318.3.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: "writable CTEs"  (David Fetter <david@fetter.org>)
Responses Re: "writable CTEs"  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
List 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>.




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: "writable CTEs"
Next
From: Tom Lane
Date:
Subject: Re: the number of file descriptors when using POSIX semaphore