Re: ENUM vs DOMAIN vs FKyed loookup table

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: ENUM vs DOMAIN vs FKyed loookup table
Дата
Msg-id gs4ljg$hkd$1@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на ENUM vs DOMAIN vs FKyed loookup table  (Mario Splivalo <mario.splivalo@megafon.hr>)
Список pgsql-sql
On 2009-04-12, Dirk Jagdmann <jagdmann@gmail.com> wrote:
>> When you need to choose between enum types, domain types or lookup tables
>> with foreign keys, what do you usualy choose?
>
> When I have a column with valid values that I know when writing my
> tables and that will *never* change I use an enum. For example a human
> gender type (and remember that there are 4 values for human sex if you
> want to model it completely).

"lambda moo" has even more genders than that.



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

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: changing multiple pk's in one update
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgres process resident size does not drop after killing statement