Re: How to modify ENUM datatypes? - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: How to modify ENUM datatypes?
Date
Msg-id 20080425092956.GB4126@merkur.hilbert.loc
Whole thread Raw
In response to Re: How to modify ENUM datatypes?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
On Wed, Apr 23, 2008 at 05:18:12PM -0600, Scott Marlowe wrote:

> >   hermaphrodite
> >   transgender with female phenotype
> >   transgender with male phenotype

> the most common and easiest is intersex.

The political correctness of any one term changes over time.
The above list should close the circle if phenotype and
genotype are taken into account:

male (g: m, p: m)
female (g: f, p: m)
hermaphrodite or intersex (g: f+m, p: f+m)
 (note this also includes mosaic -- extremely rare)
transgender f pheno (g: f+m, p: f)
transgender m pheno (g: f+m, p: f)

> I would put it that gender is not so easily defined, which makes it a
> poor choice for enum.
That surely is the last word on it also from my point of
view.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: How to modify ENUM datatypes?
Next
From: Karsten Hilbert
Date:
Subject: Re: How to modify ENUM datatypes?