From: Chris Browne <cbbrowne@acm.org>
Subject: Re: ENUM vs DOMAIN vs FKyed loookup table
Date: Wed, 15 Apr 2009 12:43:07 -0400
Organization: cbbrowne Computing Inc
Lines: 32
Message-ID: <87y6u1hnqc.fsf@dba2.int.libertyrms.com>
References: <49DCDA27.4090901@megafon.hr>
	<5d0f60990904121108y7f5dbb7aydf2105b68bceab12@mail.gmail.com>
	<gs4ljg$hkd$1@reversiblemaps.ath.cx>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Gnus/5.110006 (No Gnus v0.6) XEmacs/21.4.22 (linux)
Cancel-Lock: sha1:stmrVfJFj+rGCzxm5FpgXZXQ6qk=
To: pgsql-sql@postgresql.org

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