Обсуждение: OUTER JOIN doesn't work on pgSQL 7.1.2

Поиск
Список
Период
Сортировка

OUTER JOIN doesn't work on pgSQL 7.1.2

От
"Alex Glikson"
Дата:
Hello!

I have PostgreSQL 7.1.2 on Linux.
When I try to use outer join, I get an error message:
ERROR:  OUTER JOIN is not yet supported

I understand from the release notes, that starting with version 7.1 there
should not be any problems with OUTER JOINs.

What could be the problem?

Thanks in advance,
   Alex








Re: OUTER JOIN doesn't work on pgSQL 7.1.2

От
Tom Lane
Дата:
"Alex Glikson" <agliks@technion.ac.il> writes:
> I have PostgreSQL 7.1.2 on Linux.
> When I try to use outer join, I get an error message:
> ERROR:  OUTER JOIN is not yet supported

You are running 7.0, not 7.1.  Try "select version()" if you
don't think so.
        regards, tom lane