That not including Genetics, where and individual could have multiple X Chromomes individuals Or be XY - female times those other 6 (or 7). ----- Original Message ----- From: "brian" <brian@xxxxxxxxxxxxxxxx> To: <pgsql-general@xxxxxxxxxxxxxx> Sent: Friday, December 08, 2006 9:19 AM Subject: Re: [GENERAL] Male/female > 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 >
