Horton

TIP 9: the planner will ignore... & datatypes

Marc Mamin <m.mamin@gmx.net>

View thread View on postgr.es
From: "Marc Mamin" <m.mamin@gmx.net>
To: pgsql-performance@postgresql.org
Date: 2005-06-01T09:45:06Z
Lists: pgsql-performance 
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
++ Jetzt anmelden & testen ++ http://www.gmx.net/de/go/promail ++