Re: Oracle 'connect by prior' now eaiser in 7.3? - Mailing list pgsql-sql

From Joe Conway
Subject Re: Oracle 'connect by prior' now eaiser in 7.3?
Date
Msg-id 3F6FC51F.6090105@joeconway.com
Whole thread Raw
In response to Oracle 'connect by prior' now eaiser in 7.3?  ("Merrall, Graeme" <gmerrall@team.aol7.com.au>)
List pgsql-sql
Merrall, Graeme wrote:
> Am I right in thinking that recursive procedures and procs returning row
> sets would allow us to better emulate this behaviour? As anyone looked
> at it yet?
> 

See connectby() in contrib/tablefunc. Someone was working on SQL99 
recursive queries but it didn't get done for 7.4 -- perhaps it will be 
in 7.5. In the meantime, connectby() is in 7.3 and might work for you.

HTH,

Joe



pgsql-sql by date:

Previous
From: Christopher Browne
Date:
Subject: Re: selecting duplicate records
Next
From: "A.Bhuvaneswaran"
Date:
Subject: Re: Using sql statements in file