From: | "Rob Wultsch" <wultsch(at)gmail(dot)com> |
---|---|
To: | "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org, "Karsten Hilbert" <Karsten(dot)Hilbert(at)gmx(dot)net> |
Subject: | Re: How to modify ENUM datatypes? |
Date: | 2008-04-23 21:56:24 |
Message-ID: | 2c5ef4e30804231456p4083cd34x3d7eb08735b77b31@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Apr 23, 2008 at 2:51 PM, Robert Treat
<xzilla(at)users(dot)sourceforge(dot)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(at)gmail(dot)com
wultsch (aim)
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2008-04-23 22:19:53 | Re: Need to update all my 60 million rows at once without transactional integrity |
Previous Message | Robert Treat | 2008-04-23 21:51:48 | Re: How to modify ENUM datatypes? |