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

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




pgsql-hackers by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: Propose RC1 for Friday ...
Next
From: Reinhard Max
Date:
Subject: Re: [ANNOUNCE] PostgreSQL v7.3b5 Packaged for Testing ...