Re: connectby_reverselookup()

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

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-06-27 23:40:47 Re: connectby_reverselookup()
Previous Message Joe Conway 2003-06-27 23:21:14 Re: ERROR: tuplestore_gettuple: invalid state

Browse pgsql-patches by date

  From Date Subject
Next Message Nabil Sayegh 2003-06-27 23:40:47 Re: connectby_reverselookup()
Previous Message Kim Ho 2003-06-27 22:28:27 Re: Allow setObject(x,y,Types.BIT) if y is a Number &