Обсуждение: select with recursive support

Hi all

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.

Does anybody know about the status of this feature, e.g. is it something
bound to be implemented soon or is there no point in waiting for it at
the moment?


Bye and thanks for Postgres
Tim

Sascha Bohnenkamp <asbohnenkamp@gmx.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

> 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"
no problem for me

> 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.
that was what I want to say, at least there exists a (non free) working
solution