Forum OpenACS Development: Postgres 7.1 prebuild - first report.
OUTER JOINS ARE IN!
Yessir! Yes'm! Woo-hoo!
Throw those eight-way union selects into the toilet!
Let us know about stability and other issues if you run into them.
PG Rocks !
Conversion's a lot easier from Oracle outer join syntax to Postgres outer join syntax, and once down will work on InterBase. And the SQL92 syntax is clearer anyway, AFAIC, because it clearly differentiates joins from qualification expressions. That's true for inner as well as outer joins. Joins are a fundamentally different operation than scalar expressions...
Not that I'm going to propose rewriting all the queries to use SQL92 syntax on inner joins, that would be a lot of work.
So this will be a big worksaver even though syntax conversion's necessary. And the resulting queries will be more efficient than the union equivalent, too...