Postgres Pro
Downloads
Home   >   mailing lists

Re: How to navigate tree without CONNECT BY? - Mailing list pgsql-general

From Joe Conway
Subject Re: How to navigate tree without CONNECT BY?
Date
Msg-id 3FE1F352.8010000@joeconway.com
Whole thread Raw
In response to How to navigate tree without CONNECT BY?  ("D. Dante Lorenso" <dante@lorenso.com>)
Responses Re: How to navigate tree without CONNECT BY?  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-general
Tree view 
D. Dante Lorenso wrote:
> I have a simple table that I'd like to query to pull
> out a heirarchy from a tree relationship.  What is the
> best way to do this without a 'CONNECT BY' clause like
> Oracle has?

See connectby() in contrib/tablefunc.

Joe

pgsql-general by date:

Previous
From: Ron St-Pierre
Date:
Subject: Re: Function Returning SETOF Problem
Next
From: Tom Lane
Date:
Subject: Re: functions returning sets