RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4

A little adjustment : SOME queries work with the new binary and the old indexes. Many other don't, as Tom and Hiroshi figured.
With a new binary and after reloding the DB, every seems to work correctly.

Nicolas Huillard

-----Message d'origine-----
De: Nicolas Huillard [SMTP:nhuillard(at)ghs(dot)fr]
Date: vendredi 28 janvier 2000 22:42
À: pgsql-general(at)hub(dot)org; pgsql-sql(at)hub(dot)org
Objet: RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4

Thank to everybody, I recompiled Postgres and tested it on the same DB : the offending SELECT worked, without any index regeneration. Maybe the order in which the items where inserted in the table (using COPY, before creating the index) made it working.
...