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(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Evgen Potemkin
> Sent: Friday, 15 November 2002 5:38 PM
> To: pgsql-hackers(at)postgresql(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>