[GENERAL] Oracle outer join syntax

2006-04-05 Thread Stefan Nobis
Hi. Is there any way (or working solution) to extend PostgreSQL to accept Oracles outer join syntax with '(+)'? Any pointers to docs on how to do this myself are also appreciated. -- Until the next mail..., Stefan. ---(end of broadcast)--- TIP 5:

Re: [GENERAL] Oracle outer join syntax

2006-04-05 Thread Stefan Nobis
Csaba Nagy <[EMAIL PROTECTED]> writes: > Why would you do that ? If you need a solution which works both on > postgres and oracle, use the standard outer join syntax supported by > postgres - it is supported by the latest oracle versions too. Because there are tons of legacy code I'd have to conv

Re: [GENERAL] Oracle outer join syntax

2006-04-05 Thread Stefan Nobis
Csaba Nagy <[EMAIL PROTECTED]> writes: > Why would you do that ? If you need a solution which works both on > postgres and oracle, use the standard outer join syntax supported by > postgres - it is supported by the latest oracle versions too. BTW: You have to use the cost based optimizer (new syn

Re: [GENERAL] Oracle outer join syntax

2006-04-05 Thread Stefan Nobis
Csaba Nagy <[EMAIL PROTECTED]> writes: > both postgres and Oracle, and I have to say it took quite some time > and a few nasty surprises until everything was stable Thank you very much for your comments. -- Until the next mail..., Stefan. pgpV8KsgMY9JV.pgp Description: PGP signature

Re: [GENERAL] Oracle outer join syntax

2006-04-05 Thread Stefan Nobis
Tom Lane <[EMAIL PROTECTED]> writes: > Sounds like both your database and your DBA are dinosaurs ;-). Yes. > 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, Postgres is for use with an extern customer, so the c