Bug with indexing int4?

From: Yury Don <yura(at)vpcit(dot)ru>
To: pgsql-general <pgsql-general(at)postgreSQL(dot)org>
Subject: Bug with indexing int4?
Date: 2000-01-20 09:33:23
Message-ID: 17606.000120@vpcit.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

I have created the table

CREATE TABLE "tt" (
"cc" int4);
COPY "tt" FROM stdin;
-2112563299
-2111287024
-2110307960
.....

2146589610
2146589611
2146589612
\.

About 30 000 records totally

Then I am doing the following:

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)

mdb=> drop index i_tt_cc;
DROP
mdb=> select cc from tt where cc = -2112563299;
cc
-----------
-2112563299
(1 row)

Best regards,
Yury ICQ 11831432
mailto:yura(at)vpcit(dot)ru

Browse pgsql-general by date

  From Date Subject
Next Message Yury Don 2000-01-20 09:39:59 Bug with indexing int4?
Previous Message Eric van der Vlist 2000-01-20 07:35:11 Re: [GENERAL] apache logs to pgsql