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?