Hannu Krosing wrote:
> If I understood it right, RECURSIVE UNION is a way to query a tree
> structured
> table, whith parent_id's in each child row.
>
> AFAIK even have it in the TODO list ;)
>
> The LIMIT there probably limits how many levels down the tree are
> queried.
Original postgres used to be able to do this. The syntax
"retrieve* from xxx" would keep executing (eg traversing a tree) until
complete. Might be worth checking the original sources when you come to
do this.
--
Chris Bitmead
mailto:chris@bitmead.com