On Mon, 17 Feb 2003, Shridhar Daithankar wrote:
> It is very simple. Unless the indexed field and the field in query does not
> match exactly in type, the planner does not consider using index.
Actually the indexed field is an bigint field. But when a query plan is
did on a selection using indexed field as a string it actually uses the
index. Otherwise, it does a ordinary query plan (i.e an non indexed query
plan).
>
> What would be good in planner is to have field promotion like in C/C++,
> smallint->bigint->float->double as and when required. That would help a hell
> lot many people..
>
Will you please tell me how does the field promotion helps in planner.
> Bye
> Shridhar
>
--
Bye,
Deepa. K
--
Engineer,
Network Management System,
Midas Communication Technologies private Ltd,
Chennai.