[PERFORM] Index + mismatching datatypes [WAS: index on custom function; explain]

2005-11-07 Thread Enrico Weigelt
* 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

Re: [PERFORM] Index + mismatching datatypes [WAS: index on custom

2005-11-07 Thread Neil Conway
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