Skip site navigation (1) Skip section navigation (2)

Re: How to modify ENUM datatypes?

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to modify ENUM datatypes?
Date: 2008-04-25 09:35:39
Message-ID: 20080425093539.GD4126@merkur.hilbert.loc (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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).

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

In response to

pgsql-general by date

Next:From: Zdenek KotalaDate: 2008-04-25 10:41:42
Subject: Re: initdb in 8.3
Previous:From: Karsten HilbertDate: 2008-04-25 09:31:09
Subject: Re: How to modify ENUM datatypes?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group