Thread: How to retrieve a n-ary tree in SQL?

Hi,

Is there a way to get a query (of function) to retrieve a n-ary tree: 1
parent node has n children and the tree is n levels deep?

TIA

-- 
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

On 5/14/07, Joost Kraaijeveld <J.Kraaijeveld@askesis.nl> wrote:
> Is there a way to get a query (of function) to retrieve a n-ary tree: 1
> parent node has n children and the tree is n levels deep?

See:

http://search.postgresql.org/search?q=tree&m=1&l=4&d=365&s=r