Re: [HACKERS] create index regression fail
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 I'll change the lower bound to 'MA' and see if that's any more portable. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] create index regression fail
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. -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] create index regression fail
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