Peter Eisentraut <[EMAIL PROTECTED]> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers