Re: connectby_reverselookup()

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: connectby_reverselookup()
Date: 2003-06-27 23:40:47
Message-ID: 1056757246.585.7.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-patches

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-06-27 23:42:07 Re: ERROR: tuplestore_gettuple: invalid state
Previous Message Joe Conway 2003-06-27 23:26:56 Re: connectby_reverselookup()

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2003-06-28 03:18:18 Re: Missing array support
Previous Message Joe Conway 2003-06-27 23:26:56 Re: connectby_reverselookup()