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