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

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13
Date: 2013-03-19 17:03:54
Message-ID: CAADeyWix_JKwWgo5enpuZ2kfHwmoU2F6xSsBi0RbU6+w5YWrzA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)farber(at)gmail(dot)com> wrote:
> http://sqlfiddle.com/#!11/8a494/4

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-03-19 18:03:33 Re: Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13
Previous Message Alexander Farber 2013-03-19 15:10:46 Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13