Re: Oracle outer join syntax

From: Stefan Nobis <stefan-ml(at)snobis(dot)de>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: Stefan Nobis <stefan-ml(at)snobis(dot)de>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Oracle outer join syntax
Date: 2006-04-05 15:38:34
Message-ID: 87psjwghhh.fsf@snobis.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Csaba Nagy <nagy(at)ecircle-ag(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2006-04-05 15:40:16 Re: pg_dump and copy command
Previous Message Stefan Nobis 2006-04-05 15:35:42 Re: Oracle outer join syntax