Re: FW: Male/female - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: FW: Male/female
Date
Msg-id 20061211131922.GB5103@merkur.hilbert.loc
Whole thread Raw
In response to Re: FW: Male/female  ("H.J. Sanders" <hjs@rmax.nl>)
List pgsql-general
On Mon, Dec 11, 2006 at 01:34:17PM +0100, H.J. Sanders wrote:

> > I would also suggest using a *coded* gender, not "male",
> > "female" strings which will make gender-based calculations a
> > lot easier down the road.
>
> Which will also make it easier to have a "multi-langual" solution.
Which, precisely, is one of the reason GNUmed does it that
way. We then have a table gender_label which can translate
the code into a string (both English as a base language and
a local language via "select _(label) from gender_label".

(Yes, we sort of re-implemented gettext in SQL ;-)

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: "Marc Mamin"
Date:
Subject: Events tables, model discussion in regards to the performances
Next
From: "Albe Laurenz"
Date:
Subject: Re: installation problem, for Postgres 8.2.0