Re: (+) oracle notation

From: "Efrain Caro" <betsemes(at)hotmail(dot)com>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: (+) oracle notation
Date: 2000-10-19 17:37:40
Message-ID: LAW2-OE297XsFD14ihh00000866@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> SELECT <fields> FROM <tables> WHERE table1.field (+) = table2.field;
>
> This will return all appropriate rows in table1, even if no
> corresponding value exists in table2 (it'll list an empty value for that
> column in the output tuples if no value exists).

In order to do that you should put the (+) operator at the "possible nulls"
side of the equality. It should go this way:
SELECT <fields> FROM <tables> WHERE table1.field = table2.field (+);

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yohans Mendoza 2000-10-19 18:19:34 to_char
Previous Message Marko Kreen 2000-10-19 17:35:54 Re: MySQL PASSWORD('x') function workalike