Re: connectby documentation - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: connectby documentation
Date
Msg-id 20060313161207.GA70136@winnie.fuhr.org
Whole thread Raw
In response to connectby documentation  ("Daniel Caune" <daniel.caune@ubisoft.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: removing "not null" modifier
Next
From: Richard Huxton
Date:
Subject: Re: Constraint Error effect on PostgreSQL