Re: Oracle outer join syntax - Mailing list pgsql-general

From Stefan Nobis
Subject Re: Oracle outer join syntax
Date
Msg-id 87psjwghhh.fsf@snobis.de
Whole thread Raw
In response to Re: Oracle outer join syntax  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: Oracle outer join syntax  (Csaba Nagy <nagy@ecircle-ag.com>)
Re: Oracle outer join syntax  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Csaba Nagy <nagy@ecircle-ag.com> 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 syntax with rule
based optimizer yields really bad performance). And our DBA really
don't like statistics... :(

--
Until the next mail...,
Stefan.

Attachment

pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: pg_dump and copy command
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Looking for good PostgreSQL hosters