outer join not supported?

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

Responses

Browse pgsql-novice by date

  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