outer joins

From: "D Kavan" <bitsandbytes88(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: outer joins
Date: 2005-08-05 19:55:16
Message-ID: BAY102-F39DA7AE2F13E5FA686EA11D1C70@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

One the developers is saying that he can't do outer joins on postgresql.
Is this true? We have postgresql 8.02.

He is using this syntax:
select from A left outer join b on A.id=B.id;

This processes but comes back with a result like it was an inner join.

~DjK

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jason Minion 2005-08-05 20:14:20 Re: outer joins
Previous Message Scott Marlowe 2005-08-05 19:49:22 Re: tweak config file to increase pg_dump speed on pg 8.02