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

From Josh Berkus
Subject Re: Proposal of hierarchical queries, a la Oracle
Date
Msg-id web-1829100@davinci.ethosmedia.com
Whole thread Raw
In response to Proposal of hierarchical queries, a la Oracle  (Evgen Potemkin <evgent@ns.terminal.ru>)
Responses Re: Proposal of hierarchical queries, a la Oracle  (Evgen Potemkin <evgent@ns.terminal.ru>)
List pgsql-sql
Evgren,

> 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;

You'll be thrilled to know that this has already been implemented in
PostgreSQL 7.3, as a /contrib module, by Joe Conway.

Download 7.3b5 now if you can't wait; Joe would like more people to
test his module, anyway.

-Josh Berkus


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: INDEX PROBLEMS ?
Next
From: "LR"
Date:
Subject: Re: execute a query in an other db