On Sat, Apr 03, 2004 at 13:51:56 -0500, Gabriel Weinberg <[EMAIL PROTECTED]> wrote: > > 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.
Depending on what you want to do, you probably either want to cast the value to an int explicitly or combine that with a test (using a stable function) to make sure the number is actually an integer. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
