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. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL