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