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

From Rick Gigger
Subject Re: How to navigate tree without CONNECT BY?
Date
Msg-id 005e01c3c666$ecc80080$0700a8c0@trogdor
Whole thread Raw
In response to How to navigate tree without CONNECT BY?  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-general
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
>


pgsql-general by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: [pgsql-hackers-win32] UTF support in WIN32 native and Lower/Upper in 7.5 release
Next
From: Andrew Sullivan
Date:
Subject: Re: Salvage older PostgreSQL data disk - help?