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

From Rob Wultsch
Subject Re: How to modify ENUM datatypes?
Date
Msg-id 2c5ef4e30804231456p4083cd34x3d7eb08735b77b31@mail.gmail.com
Whole thread Raw
In response to Re: How to modify ENUM datatypes?  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
On Wed, Apr 23, 2008 at 2:51 PM, Robert Treat
<xzilla@users.sourceforge.net> wrote:
> On Wednesday 23 April 2008 14:10, Karsten Hilbert wrote:
>  > On Wed, Apr 23, 2008 at 12:38:48PM +0200, Andreas 'ads' Scherbaum wrote:
>  > > Yes. You should/can use ENUM for something like 'gender':
>  > > male, female, unknown. You don't need to add other values ever (yeah, i
>  > > skipped some special cases).
>  >
>  > I was gonna say ! :-)
>  >
>  > Add
>  >
>  >  hermaphrodite
>  >  transgender with female phenotype
>  >  transgender with male phenotype
>  >
>  > and you should be set from current medical science's point
>  > of view ;-)
>  >
>
>  The standard is unknown, male, female, and n/a.

Both unknown and n/a sounds like NULL to me.
--
Rob Wultsch
wultsch@gmail.com
wultsch (aim)

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: How to modify ENUM datatypes?
Next
From: Tom Allison
Date:
Subject: Re: Need to update all my 60 million rows at once without transactional integrity