outer join not supported?
| От | Eugene Lee |
|---|---|
| Тема | outer join not supported? |
| Дата | |
| Msg-id | 20010301151441.D539@anime.net обсуждение |
| Ответы |
Re: outer join not supported?
|
| Список | 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@anime.net
В списке pgsql-novice по дате отправления: