Re: ENUM vs DOMAIN vs FKyed loookup table

Поиск
Список
Период
Сортировка
От Chris Browne
Тема Re: ENUM vs DOMAIN vs FKyed loookup table
Дата
Msg-id 87y6u1hnqc.fsf@dba2.int.libertyrms.com
обсуждение исходный текст
Ответ на ENUM vs DOMAIN vs FKyed loookup table  (Mario Splivalo <mario.splivalo@megafon.hr>)
Список pgsql-sql
jasen@xnet.co.nz (Jasen Betts) writes:
> 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.

I'm not so sure about that...

I suspect what you're thinking of are "Spivak pronouns," which aren't
indication of gender...  Instead, they represent a way of declining to
indicate gender.

It appears that what LambdaMOO has is not a larger number of genders,
but rather a large number of ways to *indicate* gender, some of which
(e.g. - Spivak pronouns) actually decline to do so.

This is more or less equivalent to setting TZ/PGTZ or LC_LANGUAGE to
get the system to output values in some format that you prefer.

It may be that LambdaMOO has some ways to indicate sexual preferences,
but sexual preferences are not the same thing as gender.
-- 
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://linuxdatabases.info/info/linuxxian.html
"The only thing  better than TV with the  sound off is  Radio with the
sound off." -- Dave Moon


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgres process resident size does not drop after killing statement
Следующее
От: Steve Midgley
Дата:
Сообщение: How to count from a second table in an aggregate query?