Peter Eisentraut <peter_e@gmx.net> writes:
> 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?
Making the commutator operator where you need it *is* a general solution.
I think there's a syntactic-ambiguity reason why the spec is like that...
regards, tom lane