Stefan Nobis <[EMAIL PROTECTED]> writes: > [ still on Oracle8 ] > BTW: You have to use the cost based optimizer (new syntax with rule > based optimizer yields really bad performance). And our DBA really > don't like statistics... :(
Sounds like both your database and your DBA are dinosaurs ;-). If you can't get your DBA to update from Oracle 8 to modern Oracle, you've got zip chance of persuading him to deal with Postgres, so I think you're wasting your time worrying about left-join syntax. After you waste a man-year or so on that, he'll just find something else to complain about. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster