From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: select with recursive support |
Date: | 2007-11-21 14:53:25 |
Message-ID: | 60lk8rabve.fsf@dba2.int.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sascha Bohnenkamp <asbohnenkamp(at)gmx(dot)de> writes:
>> I saw on the todo list that the "with recursive" option for selects
>> (equivalent to oracle's connect by, as far as I know) is on the todo
>> list for postgresql, but apparently not for the upcoming 8.3 release.
> the postgresql derivate enterprisedb has this feature
> (exactly the oracle syntax)
What is intended for PostgreSQL is decidedly NOT the "Oracle syntax"
(which more or less predetermines a special case of recursion), but
rather the "WITH [definition] select [which can reference
[definition]]" approach seen both in DB2 and the SQL 2003 standard.
There have been a couple of abortive starts to this; I seem to recall
someone having offered to work on it in the 8.4 branch.
--
select 'cbbrowne' || '@' || 'linuxfinances.info';
http://linuxfinances.info/info/oses.html
"The Unix philosophy is to provide some scraps of metal and an
enormous roll of duct tape. With those -- and possibly some scraps of
your own -- you can conquer the world." -- G. Sumner Hayes
From | Date | Subject | |
---|---|---|---|
Next Message | Sascha Bohnenkamp | 2007-11-21 15:09:03 | Re: select with recursive support |
Previous Message | Reg Me Please | 2007-11-21 14:21:57 | Table filter |