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'.
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
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 'axyz' ~ '(.)\1\1';
WARNING: nonstandard use of escape in a string literal
LINE 1: select 'axyz' ~ '(.)\1\1';
2013/3/22 Alexander Farber alexander.far...@gmail.com:
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:
On 22 March 2013 16:08, Alexander Farber alexander.far...@gmail.com 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
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: