Forum OpenACS Development: Response to Outer joins and .xql files

Collapse
Posted by Dan Wickstrom on
The .xql file contains sql92 compliant queries, so if you have an outer join in the .xql file it will also be used for postgresql, since postgresql supports sql92 compliant outer join syntax.

Oracle on the other hand, uses a non-compliant syntax for outer joins, so it is necessary to have a separate version in -oracle.xql that is only used when oracle is the back-end db.