On 17 Feb 2003 at 15:14, Deepa wrote:
> On Mon, 17 Feb 2003, Shridhar Daithankar wrote:
>
> > when you say id=2, it uses default int type which is smallint, AFAIK. So
> > smallint != bigint and hence planner does not consider using index.
>
> But even when a number that has a value of 4 bytes is set in the where
> condition, the planner is not uses indexed scan. In this case how come
> this will take the number as small int. Is their any other reason for
> that.
4 bytes != bigint.
Bye
Shridhar
--
wok, n.: Something to thwow at a wabbit.