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