Re: [SQL] recursive SQL and with clause

2006-11-16 Thread Jonah H. Harris
On 11/15/06, Christopher Browne <[EMAIL PROTECTED]> wrote: If I recall correctly, Jim Nasby was considering it; he hadn't heard much interest back, and got to other things in the 8.2 cycle. I was working on it for 8.2, but it didn't make it. Mark Cave-Ayland will probably be picking it up for

Re: [SQL] recursive SQL and with clause

2006-11-15 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (chrisj) belched out: > I was just wondering when we could reasonably expect recursive SQL to be > added to Postgres? > > I saw some posts from 2004 that made it sound like it was imminent, > but I guess something went wrong? I believe t

[SQL] recursive SQL and with clause

2006-11-15 Thread chrisj
I was just wondering when we could reasonably expect recursive SQL to be added to Postgres? I saw some posts from 2004 that made it sound like it was imminent, but I guess something went wrong? I believe the WITH clause is a pre-requisite for recursive SQL, however I do find the WITH clause also

Re: [SQL] recursive sql (using the sort_key method)

2003-09-06 Thread Mark Stosberg
In article <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> wrote: > > can anyone recommend a good reference source for doing recursive sql on > postgresql? i want to do something similar to a BOM expansion. (i.e. i need > to traverse a self-referencing table that stores a tree structure and answer > a qu

Re: [SQL] recursive sql

2003-09-05 Thread sad
Good day On Friday 05 September 2003 21:41, you wrote: > can anyone recommend a good reference source for doing recursive sql on > postgresql? i want to do something similar to a BOM expansion. (i.e. i need > to traverse a self-referencing table that stores a tree structure and > answer a question

[SQL] recursive sql

2003-09-05 Thread floyds
can anyone recommend a good reference source for doing recursive sql on postgresql? i want to do something similar to a BOM expansion. (i.e. i need to traverse a self-referencing table that stores a tree structure and answer a question like "Get me A and all of A's descendents") Regards, Floyd S

[SQL] Recursive SQL

2000-08-03 Thread database
Dear all, Is postgresql supporting recursive sql? If no, how can my sql to change for recursive function ( on 4 or 5 levels are needed ) ? Many thanks! Best regards, Boris