bugreport

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name :Yury Don
Your email address :yura(at)vpcit(dot)ru

System Configuration
---------------------
Architecture (example: Intel Pentium) :Intel Pentium,
Intel Pentium II Celeron

Operating System (example: Linux 2.0.26 ELF) :Linux 2.0.36 Debian,
Linux 2.2.12 Debian,

PostgreSQL version (example: PostgreSQL-6.5.2):PostgreSQL-6.5.2,
PostgreSQL-6.5.2

Compiler used (example: gcc 2.8.0) :

Please enter a FULL description of your problem:
------------------------------------------------
Query "select ... from ... where ... = ..."
doesn't work properly for the indexed table with field type int4
on certain set of data.

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
\connect - postgres
DROP TABLE "tt";
CREATE TABLE "tt" (
"cc" int4);
COPY "tt" FROM stdin;
-2112563299
-2111287024
-2110307960
....
2146589610
2146589611
2146589612
\.

about 30 000 records totally

mdb=> select cc from tt where cc = -2112563299;
cc
-----------
-2112563299
(1 row)

mdb=> create index i_tt_cc on tt (cc);
CREATE
mdb=> select cc from tt where cc = -2112563299;
cc
--
(0 rows)

This happens only with large data set where are negative and positive
values.
The full data set is accessible on the http://www.vpcit.ru/tt.gz

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------