From: Joe Conway <mail@joeconway.com>
To: Merrall, Graeme <gmerrall@team.aol7.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: Oracle 'connect by prior' now eaiser in 7.3?
Date: Mon, 22 Sep 2003 20:59:27 -0700
Message-ID: <3F6FC51F.6090105@joeconway.com> (raw)
In-Reply-To: <B7AD8B4B4A337741B62E633B4827ADD90E2C08@svrexc02.aolau.ops.au.office.aol.com>
References: <B7AD8B4B4A337741B62E633B4827ADD90E2C08@svrexc02.aolau.ops.au.office.aol.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mail@joeconway.com, gmerrall@team.aol7.com.au
Subject: Re: Oracle 'connect by prior' now eaiser in 7.3?
In-Reply-To: <3F6FC51F.6090105@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox