Re: Join efficiency - Mailing list pgsql-general

From Richard Huxton
Subject Re: Join efficiency
Date
Msg-id 4135C765.3050802@archonet.com
Whole thread Raw
In response to Re: Join efficiency  (John Sidney-Woollett <johnsw@wardbrook.com>)
List pgsql-general
John Sidney-Woollett wrote:
> Does anyone know if there is a postgres shorthand for Oracle's (+)
> notation to denote an outer join?
>
> eg
>
> SELECT * from a, b where a.x = b.x (+)

Just the standard LEFT JOIN ... afaik

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: John Sidney-Woollett
Date:
Subject: Re: Join efficiency
Next
From: "Michael Paesold"
Date:
Subject: Re: Join efficiency