Re: Referencing parts captured by round brackets in a regex in 8.4.13 - Mailing list pgsql-general

2013/3/22 Alexander Farber <alexander.farber@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