Re: PostgreSQL Outer Joins - Mailing list pgsql-general

From Doug McNaught
Subject Re: PostgreSQL Outer Joins
Date
Msg-id m3g06i52cm.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to PostgreSQL Outer Joins  ("Campano, Troy" <Troy.Campano@LibertyMutual.com>)
List pgsql-general
"Campano, Troy" <Troy.Campano@LibertyMutual.com> writes:

> Does PostgreSQL 7.1.3 support outer joins; or do you still need to use
> subqueries?

Yes, it supports outer joins.

> If it does support outer joins, does anyone know the syntax?

Same syntax as the SQL standard I think (as opposed to Oracle's which
is nonstandard).  See the docs:

http://www.us.postgresql.org/users-lounge/docs/#7.1

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: wsheldah@lexmark.com
Date:
Subject: Re: PostgreSQL Outer Joins
Next
From: Tom Lane
Date:
Subject: Re: problem with select after updating