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