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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
