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

Thank you, this works better, but -

On Fri, Mar 22, 2013 at 3:57 PM, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
> On 03/22/2013 08:53 AM, Alexander Farber wrote:
>>
>> # select 'axxxxxyz' ~ '(.)\1\1';
>> WARNING: nonstandard use of escape in a string literal
>> LINE 1: select 'axxxxxyz' ~ '(.)\1\1';
>> ^
>> HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
>> ?column?
>> ----------
>> f
>> (1 row)
>>
>>
>> The table 9-18 at
>> http://www.postgresql.org/docs/8.4/static/functions-matching.html
>> suggests that using \1 as above should be ok....

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)