Re: "writable CTEs"

Peter Geoghegan <peter.geoghegan86@gmail.com>

From: Peter Geoghegan <peter.geoghegan86@gmail.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: David Fetter <david@fetter.org>, Kevin Grittner <Kevin.Grittner@wicourts.gov>, marko.tiikkaja@cs.helsinki.fi, peter_e@gmx.net, pgsql-hackers@postgresql.org, Thom Brown <thom@linux.com>

Date: 2010-12-28T14:08:36Z

Lists: pgsql-hackers

Attachments

cte_doc.patch (text/x-patch) patch

On 28 December 2010 12:09, Robert Haas <robertmhaas@gmail.com> wrote:
> 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?

I do this all the time. Anyway, I intend for this doc patch to be
backported to 8.4 as a bugfix, which is part of the reason why it
isn't invasive - it's just a clarification. Clearly if it makes sense
for 9.1, it makes just as much sense for 9.0 and 8.4.

> 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.

Attached is a new patch written with this consideration in mind. It
also has an acronym.sgml entry for CTE, which was absent from my
earlier patch. I think David actually agreed that I was right to have
doubts.

-- 
Regards,
Peter Geoghegan