Re: Tom and Fernando: Status for "WITH RECURSIVE" - Mailing list pgsql-hackers

From Andrew Overholt
Subject Re: Tom and Fernando: Status for "WITH RECURSIVE"
Date
Msg-id 20030529125308.GA21785@redhat.com
Whole thread Raw
In response to Re: Tom and Fernando: Status for "WITH RECURSIVE"  ("Rasmus Resen Amossen" <rresena@hotmail.com>)
List pgsql-hackers
> Do you know if your implementation will support multiple childs for each 
> node or will the implementation be limited to one link from each node in 
> the tree (making the tree to a list)?

[...]

> -will I then be able to fetch all childs (and grandchilds) for a given node 
> in the above tree in one single query (fx. getting the whole tree when 
> asking for nodeid = 1 and all its childs)?
> I'm asking because I somewere heard/read that SQL3 (SQL99) does not support 
> multiple childs (but I hope you will implement the "large" version).

I'm not _that_ intimate with the spec, but I'm pretty sure that multiple
children are supported and I'm aiming for my implementation to do so as
well.

Andrew


pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: No more RH7.3 RPMs?
Next
From: pgsql@mohawksoft.com
Date:
Subject: Re: No more RH7.3 RPMs?