outer joins - Mailing list pgsql-admin

From D Kavan
Subject outer joins
Date
Msg-id BAY102-F39DA7AE2F13E5FA686EA11D1C70@phx.gbl
Whole thread Raw
Responses Re: outer joins  (Michael Fuhr <mike@fuhr.org>)
List 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



pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: tweak config file to increase pg_dump speed on pg 8.02
Next
From: "Jason Minion"
Date:
Subject: Re: outer joins