Re: PostgreSQL Outer Joins

Outer joins are supported. Look here for the syntax:

http://www.postgresql.org/idocs/index.php?sql-language.html

I believe the syntax is just standard SQL. (The (+) shorthand that Oracle
uses is not supported.)

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/


-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Campano, Troy
Sent: Monday, December 10, 2001 1:25 PM
To: Pgsql-General (pgsql-general@postgresql.org)
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