PostgreSQL Outer Joins> Does PostgreSQL 7.1.3 support outer joins; or do you
still need to use subqueries?
Yes, outer joins are supported.
> If it does support outer joins, does anyone know the syntax?
ANSI SQL.
Example:
SELECT * FROM T1 LEFT JOIN T2 ON T1.ID=T2.ID;
Greg