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
