From: Michael Fuhr <mike@fuhr.org>
To: Daniel Caune <daniel.caune@ubisoft.com>
Cc: postgresql sql list <pgsql-sql@postgresql.org>
Subject: Re: connectby documentation
Date: Mon, 13 Mar 2006 09:12:07 -0700
Message-ID: <20060313161207.GA70136@winnie.fuhr.org> (raw)
In-Reply-To: <1E293D3FF63A3740B10AD5AAD88535D201C34616@UBIMAIL1.ubisoft.org>
References: <1E293D3FF63A3740B10AD5AAD88535D201C34616@UBIMAIL1.ubisoft.org>
On Mon, Mar 13, 2006 at 10:37:37AM -0500, Daniel Caune wrote:
> I'm searching for an Oracle START WITH ... CONNECT BY PRIOR ...
> equivalence. It seems that PostgreSQL (version >= 7.4) supports a
> function connectby that provides similar feature. Unfortunately I don't
> find any documentation on that function. Could you please give me a
> link on such documentation?
connectby() is part of the contrib/tablefunc module. You'll need
to install that module and load it into your database.
Somebody has made a CONNECT BY patch but the developers have objected
to it for various reasons. Search the list archives for discussion.
--
Michael Fuhr
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: mike@fuhr.org, daniel.caune@ubisoft.com
Subject: Re: connectby documentation
In-Reply-To: <20060313161207.GA70136@winnie.fuhr.org>
* 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