Sorry seems like I am missing some thing here. What is the difference between int2 & int4 as far as index scan is concerned? I did try to update to 8.0 but it is not taking my dump from 7.4.7. If I remember right it was complaining about pg_database being not present. I posted a message on forums no response so I had to abort it. I will give it a short again when I have some time. I think pg_database belongs to pgadmin. I can drop those tables and create a dump but then if for some reason I have to restore a old dump them I will be in trouble. 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 > >
