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