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

Thank you, this works better, but -

On Fri, Mar 22, 2013 at 3:57 PM, Rob Sargent <robjsargent@gmail.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)