On 12/8/06, Joshua D. Drake <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend