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

From Alexander Farber
Subject Re: Referencing parts captured by round brackets in a regex in 8.4.13
Date
Msg-id CAADeyWi_6N+Jb-m_b3euxxr675n4rFNs9LXRvNASjBsqTio8vg@mail.gmail.com
Whole thread Raw
In response to Re: Referencing parts captured by round brackets in a regex in 8.4.13  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Referencing parts captured by round brackets in a regex in 8.4.13
Re: Referencing parts captured by round brackets in a regex in 8.4.13
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)


pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Referencing parts captured by round brackets in a regex in 8.4.13
Next
From: Victor Yegorov
Date:
Subject: Re: Referencing parts captured by round brackets in a regex in 8.4.13