Re: How to navigate tree without CONNECT BY?

From: "D(dot) Dante Lorenso" <dante(at)lorenso(dot)com>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to navigate tree without CONNECT BY?
Date: 2003-12-19 14:52:52
Message-ID: 3FE310C4.1000800@lorenso.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joe Conway wrote:

> 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.

Yep. That's what I was looking for. Had to upgrade to 7.4 and
then install the contrib stuff and import those functions into my
database.

But, what a pain in the butt. I'd think this functionality
would be so important that it'd make it into the main source.
Kinda like MD5 did.

Thanks again.

Dante

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-12-19 15:40:39 Re: [GENERAL] CASE in where statement. BUG ??
Previous Message Peter Eisentraut 2003-12-19 14:23:48 Re: [GENERAL] restore error - language "plperlu" is not trusted