Ok read about the indexes and type matches. So is this fixed in 8.0? Thanks, -Prasanth. Tom Lane wrote: > Prasanth <dbadmin@xxxxxxxxxxx> writes: > >>code data type is int2. > > > Ah-hah. So "where code > 2::int2" should work noticeably better for > you. Or you could do "where code > '2'" to avoid hard-wiring the data > type knowledge into your queries. Or just change it to int4 ;-) > Or update to 8.0. > > regards, tom lane > >
