Re: ENUM vs DOMAIN vs FKyed loookup table - Mailing list pgsql-sql

From Chris Browne
Subject Re: ENUM vs DOMAIN vs FKyed loookup table
Date
Msg-id 87y6u1hnqc.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to ENUM vs DOMAIN vs FKyed loookup table  (Mario Splivalo <mario.splivalo@megafon.hr>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres process resident size does not drop after killing statement
Next
From: Steve Midgley
Date:
Subject: How to count from a second table in an aggregate query?