2013/3/22 Alexander Farber <alexander.far...@gmail.com>: > the result is correctly "true" now, > but the warning is still there, why? > > # select 'axxxxxyz' ~ '(.)\\1\\1'; > WARNING: nonstandard use of \\ in a string literal > LINE 1: select 'axxxxxyz' ~ '(.)\\1\\1'; > ^ > HINT: Use the escape string syntax for backslashes, e.g., E'\\'. > ?column? > ---------- > t > (1 row) >
Please, check this part of the docs (note the Caution): http://www.postgresql.org/docs/8.4/static/sql-syntax-lexical.html#SQL-BACKSLASH-TABLE -- Victor Y. Yegorov -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
