Re: [SQL] Proposal of hierarchical queries, a la Oracle

[Joe Conway]

Josh Berkus wrote:

Evgren,

I want to propose the patch for adding the hierarchical queries
posibility.
It allows to construct queries a la Oracle for ex:
SELECT a,b FROM t CONNECT BY a PRIOR b START WITH cond;

You'll be thrilled to know that this has already been implemented in
PostgreSQL 7.3, as a /contrib module, by Joe Conway.

Download 7.3b5 now if you can't wait; Joe would like more people to
test his module, anyway.

I have it on my personal TODO to approach this for 7.4, but I'll be happy to focus on other things if you'd like to take this on. The connectby() function in contrib/tablefunc could be a good starting point for you.

Joe



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly