Search Postgresql Archives

Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'm trying at the psql prompt of an UTF8 database in 8.4.13:

# select 'АБВГД' ~ '^[\u0410-\u042F]{2,}$';
WARNING:  nonstandard use of escape in a string literal
LINE 1: select 'АБВГД' ~ '^[\u0410-\u042F]{2,}$';
                         ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
 ?column?
----------
 f
(1 row)


On Tue, Mar 19, 2013 at 4:10 PM, Alexander Farber
<alexander.farber@xxxxxxxxx> wrote:
> http://sqlfiddle.com/#!11/8a494/4


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux