On Aug 8, 2007, at 7:14 PM, Martijn van Oosterhout wrote:
But this is a thoroughly dead horse, lets not beat it up again.
Hah! Perhaps we could have a nice, friendly discussion on using surrogate primary keys v. string based keys? Or, I think the body of the "nulls are bad" dead horse is collecting flies if anyone wants to take a swing at it... I'll stop now. :-)
Erik Jones Software Developer | Emma® erik@xxxxxxxxxx 800.595.4401 or 615.292.5888 615.292.0777 (fax) Emma helps organizations everywhere communicate & market in style. Visit us online at http://www.myemma.com ---------------------------(end of broadcast)--------------------------- 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