On Thu, Jan 12, 2012 at 1:59 PM, Tom Lane <[email protected]> wrote: > Jaime Casanova <[email protected]> writes: >> the query where the regression fails is: > >> SELECT count(*) FROM dupindexcols >> WHERE f1 > 'LX' and id < 1000 and f1 ~<~ 'YX'; > >> my first theory was that it was because some locale because mine is >> es_EC.UTF-8 but the content of the table doesn't justify that, > > [ experiments... ] Looks like you're wrong about that. In ec_EC locale > on my machine, the test accepts these rows that are not accepted in C > locale: > > 223 | LLKAAA > 738 | LLEAAA >
oh! i remember now a thread where we talk about glibc not doing the right thing about this: http://archives.postgresql.org/message-id/[email protected] an update to that post would be that in that time CH and LL where independent letters but sorted as if they weren't, now they both were degraded to be a combination of two letters. -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
