Re: [HACKERS] Proposal of hierarchical queries, a la Oracle

2002-11-17 Thread Christopher Kings-Lynne 
Was there supposed to be a patch attached to this email?

Chris

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Evgen Potemkin
 Sent: Friday, 15 November 2002 5:38 PM
 To: [EMAIL PROTECTED]
 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 [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly
 


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[HACKERS] Proposal of hierarchical queries, a la Oracle

2002-11-15 Thread Evgen Potemkin 

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 [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly