Re: Referencing parts captured by round brackets in a regex in 8.4.13

2013/3/22 Alexander Farber <alexander(dot)farber(at)gmail(dot)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