* Yann Michel [EMAIL PROTECTED] wrote:
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
I've got a similar problem: I have to match different datatypes,
ie. bigint vs. integer vs. oid.
Of
On Mon, 2005-07-11 at 19:07 +0100, Enrico Weigelt wrote:
I've got a similar problem: I have to match different datatypes,
ie. bigint vs. integer vs. oid.
Of course I tried to use casted index (aka ON (foo::oid)), but
it didn't work.
Don't include the cast in the index definition, include