Bug #500: Cannot create View and Problems With the UNION clause

Started by PostgreSQL Bugs Listover 24 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: Bug #500: Cannot create View and Problems With the UNION clause

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