I have a table with an integer column with about 10M rows in it.
This column has an index (btree).
When I try to select a row using this column with an integer, e.g. select *
from table where id=4, it always uses the index. However, if I select try
to select a row using this column with a decimal, e.g. select * from table
where id=4.343, it skips the index entirely and does a sequential scan of
the table.
I am using v7.4.2 on Freebsd 4.9.
Gabriel
_________________
Gabriel Weinberg
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
