Re: Proposal of hierarchical queries, a la Oracle

Was there supposed to be a patch attached to this email?

Chris

> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Evgen Potemkin
> Sent: Friday, 15 November 2002 5:38 PM
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] Proposal of hierarchical queries, a la Oracle
> 
> 
> 
> Hi there!
> 
> I want to propose the patch for adding the hierarchical queries 
> posibility.
> It allows to construct queries a la Oracle for ex:
> SELECT a,b FROM t CONNECT BY a PRIOR b START WITH cond;B
> 
> I've seen this type of queries often made by adding a new type, 
> which stores
> position of row in the tree. But sorting such tree are very tricky (i
> think).
> 
> Patch allows result tree to be sorted, i.e. subnodes of each node will be
> sorted by ORDER BY clause.
> 
> with regards, evgen
> 
> ---
> .evgen
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>