Excerpts from Jaime Casanova's message of jue ene 12 16:22:17 -0300 2012: > On Thu, Jan 12, 2012 at 1:59 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > Jaime Casanova <ja...@2ndquadrant.com> 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/20081215160148.gf4...@alvh.no-ip.org > > 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.
Yeah, some of these are pretty recent developments by the "real academia de la lengua", I guess glibc hasn't gotten word about it 100% yet. On the other hand I wonder if es_EC is different from other spanish locales for some reason ... -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers