Should IS DISTINCT FROM work with ANY()?

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Should IS DISTINCT FROM work with ANY()?
Дата
Msg-id 5A910B13-5EA0-4F4B-9CCD-14A725290260@kineticode.com
обсуждение исходный текст
Ответы Re: Should IS DISTINCT FROM work with ANY()?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Howdy,

Shouldn't this work?
  postgres=# SELECT 'foo' IS DISTINCT FROM ANY(ARRAY['foo']);  ERROR:  syntax error at or near "ANY"  LINE 1: SELECT
'foo'IS DISTINCT FROM ANY(ARRAY['foo']);
 

Seems to me that IS DISTINCT FROM is just another operator, like =,  
and so it should work with ANUY(), no?

Tested on 8.2 and 8.3.

Thanks,

David




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

Предыдущее
От: Andrew Chernow
Дата:
Сообщение: PQinitSSL broken in some use cases
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: mingw check hung