Re: Boolean operators without commutators vs. ALL/ANY - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Boolean operators without commutators vs. ALL/ANY
Date
Msg-id BANLkTimedWmphrXr-6uNon-PoyfOb--=Sg@mail.gmail.com
Whole thread Raw
In response to Re: Boolean operators without commutators vs. ALL/ANY  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Boolean operators without commutators vs. ALL/ANY
List pgsql-hackers
On Sun, Jun 12, 2011 at 11:44 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> On Sun, Jun 12, 2011 at 7:46 AM, Florian Pflug <fgp@phlo.org> wrote:
>>> (B) There should be a way to use ANY()/ALL() with the
>>> array elements becoming the left arguments of the operator.
>
>> It seems to me that if we provided some way of handling this, your
>> first proposal would be moot; and I have to say I like the idea of
>> allowing this a lot more than tinkering with the operator names.
>
> There are syntactic reasons not to do that.  It'd be a lot easier just
> to provide a commutator operator for ~.

Details?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Range Types and extensions
Next
From: Robert Haas
Date:
Subject: Re: WIP: collect frequency statistics for arrays