Re: Proposal of hierarchical queries, a la Oracle - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Proposal of hierarchical queries, a la Oracle
Date
Msg-id GNELIHDDFBOCMGBFGEFOKEKBCEAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Proposal of hierarchical queries, a la Oracle  (Evgen Potemkin <evgent@ns.terminal.ru>)
List pgsql-hackers
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
> 



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: FW: PostgreSQL 7.3 Platform Testing
Next
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: char(n) to varchar or text conversion should strip trailing spaces