BUG #6690: ALL and ANY array operators

Поиск
Список
Период
Сортировка
От sergey-1987@yandex.ru
Тема BUG #6690: ALL and ANY array operators
Дата
Msg-id E1Sem9x-0006K6-CE@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #6690: ALL and ANY array operators  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6690
Logged by:          sergey
Email address:      sergey-1987@yandex.ru
PostgreSQL version: 9.1.2
Operating system:   FreeBSD 8.1
Description:=20=20=20=20=20=20=20=20

As I see in documentation,
http://www.postgresql.org/docs/current/static/functions-aggregate.html there
is an ambiguity with bool_or aggregate and ANY array operator, so bool_or
cannot has standard name ANY. So ANY should always mean array operator. But
such query produces syntax error:

select 1 =3D ANY((select ARRAY[1, 2]::integer[]))

I.e. when I try to check is some element in array, that is calculated in
subquery, I cannot. I can use:

select ARRAY[1] && (select ARRAY[1, 2]::integer[])

but what about ANY operator?
For example this works:

select 1 =3D ANY(ARRAY[1, 2]::integer[]);
select 1 in (select * from unnest(ARRAY[1, 2]::integer[]))

В списке pgsql-bugs по дате отправления:

Предыдущее
От: ms@it-infrastrukturen.org
Дата:
Сообщение: BUG #6689: socket file name convention doesn't allow different IPs and the same port for different pgclusters
Следующее
От: Andrzej Krawiec
Дата:
Сообщение: Re: BUG #6650: CPU system time utilization rising few times a day