Re: Male/female

On 12/8/06, Joshua D. Drake <jd@commandprompt.com> wrote:
> On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
> > > COPY gender (gender_pk, gender) FROM stdin;
> > > 0    (unknown)
> > > 1    Male
> > > 2    Female
> > > 3    Trans
> > > \.
> >
> >
> > Not to take this completely off track, but isn't transgendered not so
> > much a gender as it is a process of moving from one gender to another?
>
> Yes, but further I don't know of any country that recognizes anything
> but Male or Female.

what if you are maintaining a database for a surgeon who performs sex
changes? we may have to consider the element of time here!  I'd go
with a composite type with custom input and output functions (for
privacy)!  What about simple bacteria (unisexual)?  hm. maybe a new
branch of calculus is in order here.

merlin