Why does postgres not take into account my index on a bigint column ? - Mailing list pgsql-general

From Pierre-Andre Michel
Subject Why does postgres not take into account my index on a bigint column ?
Date
Msg-id 007f01c1e131$471fd480$97d0fea9@acer
Whole thread Raw
List pgsql-general
Hi,
 
I noticed that postgres does not take into account index on BIGINT column when the value specified in the WHERE condition is not quoted.
My problem is that I use third part programs that automatically generate many select queries where numeric values are not surrounded with quotes.
 
So does anybody know a way to force postgres to consider using indices on bigint columns even when the value in a where cond is not surrounded by quotes ?
 
Thanks
 
----
For instance, in the following 'header' table I have a bigint column 'objectId'. Here is what I get when running the explain command:
 
idns_dev=# explain select * from header where objectid = '47866';
 
NOTICE:  QUERY PLAN:
Index Scan using header_pkey on header  (cost=0.00..3.92 rows=1 width=552)
EXPLAIN
 
idns_dev=# explain select * from header where objectid = 47866;
 
NOTICE:  QUERY PLAN:
Seq Scan on header  (cost=0.00..2246.50 rows=1 width=552)
EXPLAIN
------
 
 
 
______________________
Pierre-André Michel
 
SmartGene SA
PSE Bâtiment C
EPFL, Ecublens
CH-1015 Lausanne
 
tél. prof.: (+4121) 693 85 84
mobile:    (+4178) 681 53 03

pgsql-general by date:

Previous
From: Philip Reimer
Date:
Subject: DataBlades
Next
From: "Ole"
Date:
Subject: Please - postgresql cannot connect?