Re: [HACKERS] create index regression fail

2012-01-12 Thread Tom Lane
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

Re: [HACKERS] create index regression fail

2012-01-12 Thread Jaime Casanova
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

Re: [HACKERS] create index regression fail

2012-01-12 Thread Alvaro Herrera
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