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

From Robert Haas
Subject Re: "writable CTEs"
Date
Msg-id AANLkTimHP3Ee6p91FSLWi5+QhTTMQK_dQSb+JfLg3QLG@mail.gmail.com
Whole thread Raw
In response to Re: "writable CTEs"  (David Fetter <david@fetter.org>)
Responses Re: "writable CTEs"  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Re: "writable CTEs"  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
On Tue, Dec 28, 2010 at 12:45 AM, David Fetter <david@fetter.org> wrote:
> I don't see how people can be relying on links to 9.1-to-be's
> documentation.

Well, it's always handy when the filenames are the same across
versions.  Ever looked at the 9.0 documentation for something and then
modified the URL to see what it looked like in 8.1 or something?

>> The main change I've made is: "WITH queries, also referred to as
>> Common table expressions or CTEs, provide a way to write subqueries
>> for use as part of a larger query". I'm concerned that this might
>> not be strictly correct, because the term "WITH query" may not be
>> exactly equivalent to the term "CTE" - WITH queries are comprised of
>> one or more CTEs, plus a main query.  Or are they?
>
> They are. :)

No, actually I think Peter has it right.  A query with one or more
common table expressions is a WITH-query.  This is a subtle difference
but could affect the way that things are phrased in the documentation.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: estimating # of distinct values
Next
From: Robert Haas
Date:
Subject: Re: UPDATE pg_catalog.pg_proc.prosrc OK?