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