Re: connectby_reverselookup() - Mailing list pgsql-novice

From Joe Conway
Subject Re: connectby_reverselookup()
Date
Msg-id 3EFCD2C0.2080501@joeconway.com
Whole thread Raw
In response to Re: connectby_reverselookup()  (Nabil Sayegh <postgresql@e-trolley.de>)
Responses Re: connectby_reverselookup()  (Nabil Sayegh <postgresql@e-trolley.de>)
List pgsql-novice
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?

Joe


pgsql-novice by date:

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