Re: Tom and Fernando: Status for "WITH RECURSIVE"

From: Andrew Overholt <overholt(at)redhat(dot)com>
To: Rasmus Resen Amossen <rresena(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tom and Fernando: Status for "WITH RECURSIVE"
Date: 2003-05-29 12:53:08
Message-ID: 20030529125308.GA21785@redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Lamar Owen 2003-05-29 15:19:42 Re: No more RH7.3 RPMs?
Previous Message ow 2003-05-29 11:26:00 No more RH7.3 RPMs?