Horton

Re: [HACKERS] Solution for LIMIT cost estimation

Chris Bitmead <chris@bitmead.com>

View thread
From: Chris <chris@bitmead.com>
To: Hannu Krosing <hannu@tm.ee>
Cc: "Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgreSQL.org
Date: 2000-02-13T12:32:50Z
Lists: pgsql-hackers 
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