Re: contrib/tree - Mailing list pgsql-hackers

From Don Baccus
Subject Re: contrib/tree
Date
Msg-id 3C5419D8.6010001@pacifier.com
Whole thread Raw
In response to Re: contrib/tree  (Peter Eisentraut <peter_e@gmx.net>)
List 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



pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: PostgreSQL v7.2rc2 Released
Next
From: Peter Eisentraut
Date:
Subject: Re: pltcl build problem on FreeBSD (was: Re: pltlc and