| 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: | Whole Thread | Raw Message | 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
| 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 |