Re: Join efficiency

From: Richard Huxton <dev(at)archonet(dot)com>
To: John Sidney-Woollett <johnsw(at)wardbrook(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Join efficiency
Date: 2004-09-01 12:58:13
Message-ID: 4135C765.3050802@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paesold 2004-09-01 14:21:31 Re: Join efficiency
Previous Message John Sidney-Woollett 2004-09-01 12:40:40 Re: Join efficiency