Re: contrib/tree

From: Don Baccus <dhogaza(at)pacifier(dot)com>
To: Hannu Krosing <hannu(at)krosing(dot)net>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: contrib/tree
Date: 2002-01-27 15:16:40
Message-ID: 3C5419D8.6010001@pacifier.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hannu Krosing wrote:

> Is there a simple query for getting all ancestors of a node ?

Yes, a recursive SQL function that returns a rowset of ancestor keys.
It works off the key directly, doesn't need to touch any tables, so is
quite fast.

--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2002-01-27 16:02:33 Re: pltcl build problem on FreeBSD (was: Re: pltlc and
Previous Message Gunaseelan Nagarajan 2002-01-27 14:22:58 Re: Bad Timestamp Format