> > I would also suggest using a *coded* gender, not "male", > "female" strings which will make gender-based calculations a > lot easier down the road.
Which will also make it easier to have a "multi-langual" solution. Henk Sanders ---------------------------(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