Skip site navigation (1) Skip section navigation (2)

[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 (view raw or flat)
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: with_subquery_gs-3.patch
Description: text/x-patch (16.7 KB)

Responses

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group