On Wed, Apr 23, 2008 at 2:51 PM, Robert Treat <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] wultsch (aim) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
