ANY/SOME/ALL with noncommutable operators

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: ANY/SOME/ALL with noncommutable operators
Date: 2008-06-19 09:31:02
Message-ID: 200806191131.04643.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zoltan Boszormenyi 2008-06-19 11:12:32 Re: posix advises ...
Previous Message Dmitry Turin 2008-06-19 09:17:34 Re: Postgres + Window manager