Thanks, I finally get it - this works fine:
# select 'axyz' ~ E'(.)\\1\\1';
?column?
--
t
(1 row)
# select 'ОШИБББКА' ~ E'(.)\\1\\1';
?column?
--
t
(1 row)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:/
On 22 March 2013 16:08, Alexander Farber wrote:
> Thank you, this works better, but -
> the result is correctly "true" now,
> but the warning is still there, why?
>
> # select 'axyz' ~ '(.)\\1\\1';
> WARNING: nonstandard use of \\ in a string literal
> LINE 1: select 'axyz' ~ '(.)\\1\
2013/3/22 Alexander Farber :
> the result is correctly "true" now,
> but the warning is still there, why?
>
> # select 'axyz' ~ '(.)\\1\\1';
> WARNING: nonstandard use of \\ in a string literal
> LINE 1: select 'axyz' ~ '(.)\\1\\1';
> ^
> HINT: Use the escape s
Thank you, this works better, but -
On Fri, Mar 22, 2013 at 3:57 PM, Rob Sargent wrote:
> On 03/22/2013 08:53 AM, Alexander Farber wrote:
>>
>> # select 'axyz' ~ '(.)\1\1';
>> WARNING: nonstandard use of escape in a string literal
>> LINE 1: select 'axyz' ~ '(.)\1\1';
>>
On 03/22/2013 08:53 AM, Alexander Farber wrote:
Hello,
how to get rid of this warning
on a PostgreSQL 8.4.13 prompt?
# select 'axyz' ~ '(.)\1\1';
WARNING: nonstandard use of escape in a string literal
LINE 1: select 'axyz' ~ '(.)\1\1';
^
HINT: Use the esc
Hello,
how to get rid of this warning
on a PostgreSQL 8.4.13 prompt?
# select 'axyz' ~ '(.)\1\1';
WARNING: nonstandard use of escape in a string literal
LINE 1: select 'axyz' ~ '(.)\1\1';
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
?col
