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