Re: How to navigate tree without CONNECT BY?

Does anyone now how the algorithm for connect by works?  Is it very
efficient for large data sets?

rg

----- Original Message -----
From: "CoL" <col@mportal.hu>
To: <pgsql-general@postgresql.org>
Sent: Friday, December 19, 2003 3:17 AM
Subject: Re: [GENERAL] How to navigate tree without CONNECT BY?


> Hi
>
> 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?
>
> use connect_by from contrib.
>
> C.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>