Re: How to modify ENUM datatypes?

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: How to modify ENUM datatypes?
Дата
Msg-id 200804231751.48705.xzilla@users.sourceforge.net
обсуждение исходный текст
Ответ на Re: How to modify ENUM datatypes?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: How to modify ENUM datatypes?
Re: How to modify ENUM datatypes?
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: Create temporary function
Следующее
От: "Rob Wultsch"
Дата:
Сообщение: Re: How to modify ENUM datatypes?