Re: Boolean operators without commutators vs. ALL/ANY

Florian G. Pflug <fgp@phlo.org>

From: Florian Pflug <fgp@phlo.org>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Peter Eisentraut <peter_e@gmx.net>, Robert Haas <robertmhaas@gmail.com>, PG Hackers <pgsql-hackers@postgresql.org>
Date: 2011-06-17T08:46:32Z
Lists: pgsql-hackers
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 "~"?

best regards,
Florian Pflug