Forum OpenACS Development: Re: Patch for PG that implements Hierarchical Queries

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