index problem

Hi,

I have an objectid field of type bigint, but when I run queries like:

select * from table where objectid=123;

index is not used on objectid even though it's declared.

However when I run:

select * from table where objectid='123';

index is used.

Is there an option I can set so that postgres starts using indexes on numberic field without requiring

conversion to varchar?

thanks,

 

Oleg