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
Import Notes
Reply to msg id not found: 20021115093003.A1DAF475C60@postgresql.org
Was there supposed to be a patch attached to this email?
Chris
Show quoted text
-----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 OracleHi 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;BI'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