James Harper wrote:
I think the answer is no, but can anyone tell me if postgresql supports the older (pre sql-92?) style outer join syntax, eg: SELECT * FROM a,b WHERE a.pk *= b.fk
I don't think that was ever part of the SQL standard - just an Oracle-ism. And no, PG doesn't support it - sorry.
-- Richard Huxton Archonet Ltd