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@ghs.fr]
Date:    vendredi 28 janvier 2000 22:42
À:    pgsql-general@hub.org; pgsql-sql@hub.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)
madeit working. 
 ...