Re: Notes about fixing regexes and UTF-8 (yet again)
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Vik Reykja <vikreykja@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, pgsql-hackers@postgresql.org
Date: 2012-02-19T04:41:55Z
Lists: pgsql-hackers
Vik Reykja <vikreykja@gmail.com> writes: > On Sun, Feb 19, 2012 at 05:03, Robert Haas <robertmhaas@gmail.com> wrote: >> On Sat, Feb 18, 2012 at 10:38 PM, Vik Reykja <vikreykja@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