> OK. Stop and think about what you're telling postgresql to do here.
>
> You're telling it to cast the field group_id to int8, then compare it to
> 9. How can it cast the group_id to int8 without fetching it? That's
> right, you're ensuring a seq scan. You need to put the int8 cast on the
> other side of that equality comparison, like:
Yeh that one was my fault :) I couldn't remember which way it went and
if 7.4.x had issues with int8 indexes..
--
Postgresql & php tutorials
http://www.designmagick.com/