Thread: Bug #500: Cannot create View and Problems With the UNION clause
Bug #500: Cannot create View and Problems With the UNION clause
From
pgsql-bugs@postgresql.org
Date:
Cortez (cortez@ejegy.hu) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Cannot create View and Problems With the UNION clause Long Description 1) VIEW I cannot create a VIEW, cause i have used the COPY command with OID. And i have giving negative number for the oid like '-2147483648' for test and the psql has return this error message: ERROR: pg_atoi: error reading "2147599903": Numerical result out of range 2) UNION Why doesnt working the following SQL command ? database=# SELECT EXISTS (SELECT 1 UNION SELECT 2); ERROR: parser: parse error at or near "union" Sample Code No file was uploaded with this report
pgsql-bugs@postgresql.org writes: > Why doesnt working the following SQL command ? > database=# SELECT EXISTS (SELECT 1 UNION SELECT 2); > ERROR: parser: parse error at or near "union" You're using an old release of Postgres. Update. (7.1.3 is current.) I don't know about your other complaint; you didn't give enough detail. regards, tom lane