Vik Reykja <vikrey...@gmail.com> writes: > On Sun, Feb 19, 2012 at 05:03, Robert Haas <robertmh...@gmail.com> wrote: >> On Sat, Feb 18, 2012 at 10:38 PM, Vik Reykja <vikrey...@gmail.com> wrote: >>> Does it make sense for regexps to have collations?
>> As I understand it, collations determine the sort-ordering of strings. >> Regular expressions don't care about that. Why do you ask? > Perhaps I used the wrong term, but I was thinking the locale could tell us > what alphabet we're dealing with. So a regexp using en_US would give > different word-boundary results from one using zh_CN. Our interpretation of a "collation" is that it sets both LC_COLLATE and LC_CTYPE. Regexps may not care about the first but they definitely care about the second. This is why the stuff in regc_pg_locale.c pays attention to collation. regards, tom lane -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers