Re: PostgreSQL Outer Joins

Yes, outer joins are supported as of 7.1. The basic syntax is:

SELECT field1, field2 FROM t1 LEFT OUTER JOIN t2 ON t1.id = t2.id

You can use LEFT OUTER JOIN, RIGHT OUTER JOIN, or FULL OUTER JOIN. See the docs
for details at http://www.postgresql.org/idocs/index.php?sql-select.html.

--Wes Sheldahl

"Campano, Troy" <Troy(dot)Campano%LibertyMutual(dot)com(at)interlock(dot)lexmark(dot)com> on
12/10/2001 01:24:41 PM

To: "Pgsql-General (pgsql-general(at)postgresql(dot)org)"
<pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com>
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [GENERAL] PostgreSQL Outer Joins

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

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

If it does not, does anyone know when it might?

Thank you for your time!

Troy Campano