From: | Eugene Lee <eugene(at)anime(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | outer join not supported? |
Date: | 2001-03-01 23:14:41 |
Message-ID: | 20010301151441.D539@anime.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)anime(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2001-03-01 23:19:12 | Re: outer join not supported? |
Previous Message | GH | 2001-03-01 22:09:25 | Re: Backing up with Postgres |