Scott Marlowe wrote:
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
David Fetter wrote:
On Fri, Dec 08, 2006 at 03:23:11PM -0000, Raymond O'Donnell wrote:
Just wondering.....how do list member represent gender when storing
details of people in a database?
I usually use a table called gender which has one TEXT column, that
being its primary key. For one client I had, there were seven rows in
this table.
Seven genders? Even San Fransisco thinks that's over the top.
Let's see.
Male
Female
Hermaphrodite
Trans (MTF)
Trans (FTM)
Neuter
and... I can't think of a seventh possibility.
As has been pointed out, some governments forbid the collection of
gender information, so the seventh would be unknown/unreported.
brian
---------------------------(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
