Re: Male/female

From: Jorge Godoy <jgodoy(at)gmail(dot)com>
To: Madison Kelly <linux(at)alteeve(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, John Meyer <john(dot)l(dot)meyer(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Male/female
Date: 2006-12-08 23:04:04
Message-ID: 87d56udm6z.fsf@ieee.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Madison Kelly <linux(at)alteeve(dot)com> writes:

> Some people argue that gender is a spectrum. If you want to be very
> inclusive. Maybe you could use a 'float' and stick with 0 = woman, 1 = man
> (self documenting after all) with the option of '0.1 - 0.9' for people who
> feel "in between". How efficient is 'float'? This would also work for animals
> that fall outside then normal male/female designation.

Then you can use NULL to represent unknown information but you miss the other
possibility that was pointed out: the person refused to inform the gender. To
cover all these possibilities with one single column we need a set of discrete
states.

--
Jorge Godoy <jgodoy(at)gmail(dot)com>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2006-12-08 23:21:33 Re: Male/female
Previous Message AgentM 2006-12-08 22:42:38 Re: Male/female