"Huang Ming" <huangm2000(at)sina(dot)com(dot)cn> writes:
> hi, thanks for your help. but the version of what I use is 7.1.3
> and 7.2. I try these two version and get the same result - " OUTER
> JOIN is not yet supported".
I will assert with great confidence that the server you are using is
*not* running 7.1, nor 7.2, but 7.0. That error message only exists
in 7.0.
You might possibly be using a 7.1 psql, or other client, but the
server you are connecting to is older.
regards, tom lane