Re: Boolean operators without commutators vs. ALL/ANY
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Florian Pflug <fgp@phlo.org>, PG Hackers <pgsql-hackers@postgresql.org>
Date: 2011-06-13T04:00:51Z
Lists: 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