Skip site navigation (1) Skip section navigation (2)

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

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #500: Cannot create View and Problems With the UNION clause
Date: 2001-10-29 10:29:06
Message-ID: 200110291029.f9TAT6A08515@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Cortez (cortez(at)ejegy(dot)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


Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2001-10-29 17:44:09
Subject: Re: ecpg - GRANT bug
Previous:From: Andy HallamDate: 2001-10-29 09:51:03
Subject: Re: Select with backslash '\' character

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group