Horton

Re: contrib/tree

Don Baccus <dhogaza@pacifier.com>

View thread
From: Don Baccus <dhogaza@pacifier.com>
To: Hannu Krosing <hannu@krosing.net>
Cc: Peter Eisentraut <peter_e@gmx.net>, Oleg Bartunov <oleg@sai.msu.su>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2002-01-27T15:16:40Z
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