Thanks Tom. Seems like having int2 after code is doing the trick. Can you please explain the reasons behind this. I Really appreciate your time. 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > >
