Re: Oracle 'connect by prior' now eaiser in 7.3?

From: Joe Conway <mail(at)joeconway(dot)com>
To: "Merrall, Graeme" <gmerrall(at)team(dot)aol7(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Oracle 'connect by prior' now eaiser in 7.3?
Date: 2003-09-23 03:59:27
Message-ID: 3F6FC51F.6090105@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A.Bhuvaneswaran 2003-09-23 05:22:24 Re: Using sql statements in file
Previous Message Christopher Browne 2003-09-23 03:13:23 Re: selecting duplicate records