Horton

Re: [HACKERS] Solution for LIMIT cost estimation

Hannu Krosing <hannu@tm.ee>

View thread
From: Hannu Krosing <hannu@tm.ee>
To: "Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, chris@bitmead.com, pgsql-hackers@postgreSQL.org
Date: 2000-02-11T16:41:11Z
Lists: pgsql-hackers 
"Ross J. Reedstrom" wrote:
> 
> 
> the SQL3 draft that Chris pointed me at (Aug94) only mentions LIMIT as a
> limit clause of a RECURSIVE UNION, whatever that is. (No time to examine
> it right now) This is from the file sql-foundation-aug94.txt.
> 

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.

---------
Hannu