Hi, I'm trying to do a LEFT JOIN and I'm getting an error telling me
that it's not supported. The log looks something like this:
Mar 1 16:36:25 mars logger: StartTransactionCommand
Mar 1 16:36:25 mars logger: query: SELECT t1.a1, t2.b
Mar 1 16:36:25 mars logger: ^IFROM t1 LEFT JOIN t2
Mar 1 16:36:25 mars logger: ^ION t1.a1 = t2.a2
Mar 1 16:36:25 mars logger: ^IORDER BY t1.a1
Mar 1 16:36:25 mars logger: ERROR: OUTER JOIN is not yet supported
Mar 1 16:36:25 mars logger: AbortCurrentTransaction
I'm running PostgreSQL 7.0.3. There's nothing in the release docs
saying that there's no outer join support, so I'm wondering if I need
to reconfigure or recompile something. Thanks in advance!
--
Eugene Lee
eugene@anime.net