Re: How to modify ENUM datatypes?

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)