Re: Boolean operators without commutators vs. ALL/ANY

Excerpts from Florian Pflug's message of vie jun 17 04:46:32 -0400 2011:
> On Jun17, 2011, at 03:42 , Alvaro Herrera wrote:
> > To make matters worse, our delimiters for regexes are the same as for
> > strings, the single quote.  So you get
> > 
> > foo =~ 'bar'    /* foo is the text column, bar is the regex */
> > 'bar' =~ foo    /* no complaint but it's wrong */
> > 
> > 'bar' ~= foo    /* okay */
> > 'foo' ~= bar    /* no complaint but it's wrong */
> > 
> > How do I tell which is the regex here?  If we used, say, /, that would
> > be a different matter:
> 
> How is this different from the situation today where the operator
> is just "~"?

Err, we don't have commutators today?

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support