Re: Boolean operators without commutators vs. ALL/ANY

Florian G. Pflug <fgp@phlo.org>

From: Florian Pflug <fgp@phlo.org>
To: Ross J. Reedstrom <reedstrm@rice.edu>
Cc: pgsql-hackers@postgresql.org
Date: 2011-06-17T15:21:10Z
Lists: pgsql-hackers
On Jun17, 2011, at 17:15 , Ross J. Reedstrom wrote:
> On Fri, Jun 17, 2011 at 10:20:04AM -0400, Alvaro Herrera wrote:
>> Excerpts from Florian Pflug's message of vie jun 17 10:03:56 -0400 2011:
>> 
>>> How is that worse than the situation with "=~" and "~="?
>> 
>> With =~ it is to the right, with ~= it is to the left.
> 
> To throw my user opinion into this ring (as a long time user of regexes
> in many different systems) I've always taken the ~ to be short hand for
> the 'approximately' notation (a squiggly equals) which has good semantic
> match in my mind: a regex match is sort of a fuzzy equality. With that
> model, the suggested pair is fairly mnemonic - the 'fuzzy' part i(the
> pattern) is next to the squiggles, the 'concrete' part goes by the
> equals.

Hey, that's my mnemonic device! ;-)

best regards,
Florian Pflug