[8.4] Updated WITH clause patch (non-recursive)

From: Neil Conway <neilc(at)samurai(dot)com>
To: pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>
Subject: [8.4] Updated WITH clause patch (non-recursive)
Date: 2008-01-27 07:58:40
Message-ID: 1201420721.1204.35.camel@goldbach
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Attached is an updated version of Greg Stark's patch to add support for
the non-recursive variant of the SQL99 WITH clause[1]. I haven't looked
at the actual functionality of the patch yet (which is quite trivial) --
I just fixed up bitrot and the like. I also removed support for
RECURSIVE and the search/cycle clause, along with their associated
keywords -- the current patch doesn't approach anything close to adding
support for the non-recursive case, so it seems like a net loss to add
additional keywords for no gain in functionality.

Remaining work is to review the guts of the patch (which shouldn't take
long), and write documentation and regression tests. I'm personally
hoping to see this get into the tree fairly early in the 8.4 cycle,
pending discussion of course.

-Neil

[1] http://archives.postgresql.org/pgsql-patches/2007-03/msg00139.php
http://archives.postgresql.org/pgsql-patches/2007-04/msg00055.php

Attachment Content-Type Size
with_subquery_gs-3.patch text/x-patch 16.7 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Gregory Stark 2008-01-27 09:17:23 Re: [8.4] Updated WITH clause patch (non-recursive)
Previous Message Tom Lane 2008-01-26 19:27:43 Re: sinval contention reduction