On Thu, Apr 24, 2008 at 10:25:44AM +0200, Andreas 'ads' Scherbaum wrote: > If you define a medical database, you have to extend the ENUM values a > bit, but even then you know the possible values in advance Considering scary genetic experiments I wouldn't even be sure about that. > It all depends on the use case, just like ENUM itself. Absolutely. Maybe another outcome of this discussion might be that PostgreSQL documentation - as thorough as the whole project is set up - should never use gender as an example for ENUM (it doesn't now in 8.3 docs btw). Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346