Prasanth <dbadmin(at)nqadmin(dot)com> writes:
> Seems like having int2 after code is doing the trick.
> Can you please explain the reasons behind this.
When you write "int2col > 2", the operator that is selected is int2-gt-int4.
However the index on an int2 column can only deal with int2-gt-int2.
8.0 generalized the index mechanism enough to allow int2 indexes to deal
with int2-gt-int4, but in earlier releases you have to take care to make
the constant an int2.
int8 columns have the same issue from the other direction ...
regards, tom lane