Re: How to modify ENUM datatypes?

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to modify ENUM datatypes?
Date: 2008-04-25 09:29:56
Message-ID: 20080425092956.GB4126@merkur.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2008-04-25 09:31:09 Re: How to modify ENUM datatypes?
Previous Message Karsten Hilbert 2008-04-25 09:25:05 Re: How to modify ENUM datatypes?