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 <[EMAIL PROTECTED]> 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 > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
