[PERFORM] TIP 9: the planner will ignore... datatypes

2005-06-01 Thread Marc Mamin
TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match But INT2, INT4, INT8 and SERIAL are considered to be a unique datatype. Am I Right? Thanks, Marc -- Geschenkt: 3 Monate GMX ProMail gratis + 3 Ausgaben stern gratis ++

Re: [PERFORM] TIP 9: the planner will ignore... datatypes

2005-06-01 Thread Alvaro Herrera
On Wed, Jun 01, 2005 at 11:45:06AM +0200, Marc Mamin wrote: TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match But INT2, INT4, INT8 and SERIAL are considered to be a unique datatype. Am I Right? No, they weren't when