Re: How to navigate tree without CONNECT BY?

Поиск
Список
Период
Сортировка
От D. Dante Lorenso
Тема Re: How to navigate tree without CONNECT BY?
Дата
Msg-id 3FE310C4.1000800@lorenso.com
обсуждение исходный текст
Ответ на Re: How to navigate tree without CONNECT BY?  (Joe Conway <mail@joeconway.com>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: Melanie Bergeron
Дата:
Сообщение: Re: automatic verifications
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CASE in where statement. BUG ??