Re: How to modify ENUM datatypes?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: How to modify ENUM datatypes?
Дата
Msg-id dcc563d10804231618p7ae8bcd6v7738e512217360bf@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to modify ENUM datatypes?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: How to modify ENUM datatypes?
Re: How to modify ENUM datatypes?
Re: How to modify ENUM datatypes?
Список pgsql-general
On Wed, Apr 23, 2008 at 12:10 PM, Karsten Hilbert
<Karsten.Hilbert@gmx.net> 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 ;-)

Actually, hermaphrodite specifies complete male and female genitalia,
which is impossible in humans.  While various forms of address are
available for people born with parts of both male and female
genitalia, the most common and easiest is intersex.

The folks here: http://www.isna.org/faq/ have a lot more to say about
it, and seeing as how many of them ARE intersex, I'd leave it up to
them.

While most transgender folks prefer to be referred to as their assumed
gender, there are some gender queer folks who prefer other forms of
address.

I would put it that gender is not so easily defined, which makes it a
poor choice for enum.

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

Предыдущее
От: John Gardner
Дата:
Сообщение: Re: Vacuuming Questions
Следующее
От: Chris Browne
Дата:
Сообщение: Re: Need to update all my 60 million rows at once without transactional integrity