Thank you, this works better, but -
On Fri, Mar 22, 2013 at 3:57 PM, Rob Sargent <robjsarg...@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)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
