Forum OpenACS Development: Patch for PG that implements Hierarchical Queries

Collapse
1: Patch for PG that implements Hierarchical Queries
Posted by Talli Somekh on 11/23/03 05:04 AM
Dunno if this is worth anything, but it seemed interesting:

---
http://gppl.terminal.ru/index.eng.html

This is a patch to PostgreSQL which allows it to perform hierarchical queries in Oracle's style.
----

i suppose it would suck to make users patch PG, but perhaps this tool (if it's any good) might end in the PG main (if it's any good).

talli (if he's any good)

Collapse
2: Re: Patch for PG that implements Hierarchical Queries (response to 1)
Posted by Roberto Mello on 11/23/03 08:29 PM
I followed the discussion of this patch on the PG lists.

Tom Lane has rejected this patch because apparently it's not very well done, and because the PG team would rather implement SQL99 hierarchical queries, instead of the Oracle extension (which has its own problems, like its outer join extension).

It was discussed that perhaps an Oracle compatibility syntax would be added to convert to SQL99 syntax. The Oracle syntax is simpler and easier-to-use, but less powerful and generic, like the outer join syntax.

See the following threads:

http://groups.google.com/groups?q=tom+lane+connect+by&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=20630.1065070962%40sss.pgh.pa.us&rnum=3
http://groups.google.com/groups?q=tom+lane+oracle+connect+by+group:comp.databases.postgresql.*+group:comp.databases.postgresql.*+group:comp.databases.postgresql.*&hl=en&lr=&ie=UTF-8&oe=UTF-8&group=comp.databases.postgresql.*&selm=3DE407D5.8030101%40redhat.com&rnum=2
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3DE407D5.8030101%40redhat.com&rnum=2&prev=/groups%3Fq%3Dtom%2Blane%2Boracle%2Bconnect%2Bby%2Bgroup:comp.databases.postgresql.*%2Bgroup:comp.databases.postgresql.*%2Bgroup:comp.databases.postgresql.*%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26group%3Dcomp.databases.postgresql.*%26selm%3D3DE407D5.8030101%2540redhat.com%26rnum%3D2

-Roberto

Collapse
3: Re: Patch for PG that implements Hierarchical Queries (response to 1)
Posted by Talli Somekh on 11/23/03 10:11 PM
Ah, OK. I figured there might be something weird considering that I found this patch on Freshmeat rather than through the PG community.

Thanks for the info.

talli