Hello...I though PostgreSQL supports OUTER JOIN? Do I need to compile with special options or something?
I am running PostgreSQL 7.0.3 on Linux RedHat 7.1 with Kernel 2.4
psql <<!
job=# select contact, phone from account left outer join phone on account.Id=Phone.AccountId;
ERROR: OUTER JOIN is not yet supported
!
Thanks for any help,
Jeff
Jeff Martin
704 Torrey Lane, Apartment D
Boalsburg, PA 16827
H814-466-7791
jeff@dgjc.org
www.dgjc.org