On Thu, Jun 19, 2008 at 11:31:02AM +0200, Peter Eisentraut wrote: > 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?
It's been proposed several times before, at least once by Yours Truly, without objections. I seem to recall it's a SMOP. Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers