Re: is not distinct from any(...)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: is not distinct from any(...)
Дата
Msg-id 20993.1221836020@sss.pgh.pa.us
обсуждение исходный текст
Ответ на is not distinct from any(...)  ("Robert Haas" <robertmhaas@gmail.com>)
Список pgsql-general
"Robert Haas" <robertmhaas@gmail.com> writes:
> That doesn't seem to work, because IS NOT DISTINCT FROM is not an
> operator.

Yah :-(

> So then I tried creating an operator === (anyelement,
> anyelement) that just does IS NOT DISTINCT FROM and writing:
> select 1 === any(array[1]);
> which got me:
> ERROR:  could not find array type for data type anyelement

FWIW, it seems to work in 8.3.

            regards, tom lane

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

Предыдущее
От: "Markova, Nina"
Дата:
Сообщение: Re: setting Postgres client
Следующее
От: Steve Clark
Дата:
Сообщение: Re: setting Postgres client