Thread: OUTER JOIN doesn't work on pgSQL 7.1.2

OUTER JOIN doesn't work on pgSQL 7.1.2

From
"Alex Glikson"
Date:
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

From
Tom Lane
Date:
"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