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

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Bug #500: Cannot create View and Problems With the UNION clause
Дата
Msg-id 200110291029.f9TAT6A08515@postgresql.org
обсуждение исходный текст
Ответы Re: Bug #500: Cannot create View and Problems With the UNION clause
Список pgsql-bugs
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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: probably a bug of data-type serial
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Porting issue with openssl and no /dev/random