ANY/SOME/ALL with noncommutable operators

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема ANY/SOME/ALL with noncommutable operators
Дата
Msg-id 200806191131.04643.peter_e@gmx.net
обсуждение исходный текст
Ответы Re: ANY/SOME/ALL with noncommutable operators
Re: ANY/SOME/ALL with noncommutable operators
Список pgsql-hackers
I can do

'abc' LIKE ANY (ARRAY['a%','b%'])

but not

ANY (ARRAY['abc', 'def']) LIKE '%a'

This seems to be a failing in the SQL standard. You can work around this by 
creating your own operators, but maybe there should be a general solution, as 
there are a lot of noncommutable operators and this example doesn't seem all 
that unuseful in practice.

Comments?


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

Предыдущее
От: Dmitry Turin
Дата:
Сообщение: Re: Postgres + Window manager
Следующее
От: Vanessa Gonzalez
Дата:
Сообщение: G8: SOS Cambio Climático