Re: Recursive queries? - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Recursive queries?
Date
Msg-id 200402041208.13237.josh@agliodbs.com
Whole thread Raw
In response to Recursive queries?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Recursive queries?  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
Chris, Robert

> As a side note, I thought Joe Conway also had an implementation of
> this...

Yes, we already have a connect_by function, and have had since 7.3.   Look 
in /contrib/tablefuc.   

I think that's as far as we want to go implementing Oracle's syntax, though 
*external* patches are of course good for GBorg.   If we're to implement 
recursive queries, we should implement the SQL99 standard.

-- 
-Josh BerkusAglio Database SolutionsSan Francisco



pgsql-hackers by date:

Previous
From: Michael Brusser
Date:
Subject: Question on database backup
Next
From: Neil Conway
Date:
Subject: Re: Recursive queries?