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@gmail.com> wrote:
> http://sqlfiddle.com/#!11/8a494/4