Forum OpenACS Development: Response to Postgres 7.1 prebuild - first report.

Collapse
Posted by Don Baccus on
No, the syntax is SQL92 - the same as InterBase.  Open Source databases gotta stick together...

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.