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>
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 |