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

2013-03-22 Thread Alexander Farber
Hello, unfortunately octal doesn't seem to work either - On Tue, Mar 19, 2013 at 7:03 PM, Tom Lane t...@sss.pgh.pa.us wrote: Alexander Farber alexander.far...@gmail.com writes: # select 'АБВГД' ~ '^[\u0410-\u042F]{2,}$'; WARNING: nonstandard use of escape in a string literal I think

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

2013-03-22 Thread Alexander Farber
My insert trigger for 8.4.13 works now: http://sqlfiddle.com/#!11/c74a1/3 Thank you for you help -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

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

2013-03-19 Thread Alexander Farber
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.,

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

2013-03-19 Thread Tom Lane
Alexander Farber alexander.far...@gmail.com writes: 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 I think Unicode escapes were introduced in 9.0. In 8.4 you'd probably have