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