Forum OpenACS Development: Postgres 7.1 prebuild - first report.

Collapse
1: Postgres 7.1 prebuild - first report.
Posted by Don Baccus on 11/19/00 09:00 PM
I've only tried one thing but it makes me so ecstatic that I gotta tell the world!

OUTER JOINS ARE IN!

Yessir!  Yes'm!  Woo-hoo!

Throw those eight-way union selects into the toilet!

Collapse
2: Response to Postgres 7.1 prebuild - first report. (response to 1)
Posted by Roberto Mello on 11/19/00 11:29 PM
That's great Don! Is the syntax the same as Oracle?

Let us know about stability and other issues if you run into them.

PG Rocks !

Collapse
3: Response to Postgres 7.1 prebuild - first report. (response to 1)
Posted by Don Baccus on 11/19/00 11:40 PM
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.

Collapse
4: Response to Postgres 7.1 prebuild - first report. (response to 1)
Posted by Don Baccus on 11/19/00 11:46 PM
Sorry about the extra post, in my previous I meant it's a lot easier to convert outer joins from Oracle syntax to SQL92 than it is to get rid of their use entirely via joins, as we've had to do before.

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...