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 <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
