Re: connectby_reverselookup() - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: connectby_reverselookup()
Date
Msg-id 1056757246.585.7.camel@billy
Whole thread Raw
In response to Re: connectby_reverselookup()  (Joe Conway <mail@joeconway.com>)
Responses Hierarchical Re: connectby_reverselookup()
List pgsql-novice
Am Sam, 2003-06-28 um 01.26 schrieb Joe Conway:
> Nabil Sayegh wrote:
> > What would yout think about a function that ascends a tree from a given
> > node to the topmost and returns the path as a table ?
> >
>
> Not sure I understand what you're proposing correctly, but can't you
> just reverse the parent/child id fields?

Hm, Eh, yup, that helped :)

thx

P.S: That should go into the README
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de


pgsql-novice by date:

Previous
From: Joe Conway
Date:
Subject: Re: connectby_reverselookup()
Next
From: Nabil Sayegh
Date:
Subject: Re: ERROR: tuplestore_gettuple: invalid state