IMHO you need at least five values:
Male
Female
Unknown (aka NULL)
Not Available
Not Applicable
BTW, my wife's grandfather's given name was "Pearl".
A few years ago I taught a lesson to a group of about 30 third grade
students. There were 6 students in that class with a first name pronounced
l
Madison Kelly <[EMAIL PROTECTED]> writes:
> Some people argue that gender is a spectrum. If you want to be very
> inclusive. Maybe you could use a 'float' and stick with 0 = woman, 1 = man
> (self documenting after all) with the option of '0.1 - 0.9' for people who
> feel "in between". How efficie
While this thread is tangentially interesting, due to the magic of
relational relationships, the point is really moot. If you are really
worried about various gender states in the future, just create a
table called "gender" and reference it and update it as necessary- done.
-M
Steve Crawford wrote:
Richard Troy wrote:
On Fri, 8 Dec 2006, Raymond O'Donnell wrote:
Yes, the table is used only for humans; it's part of some
administrative software I'm writing for an educational institution,
and the primary purpose of the gender column is to help the users
cope wit
Richard Troy wrote:
>
>
> On Fri, 8 Dec 2006, Raymond O'Donnell wrote:
>> Yes, the table is used only for humans; it's part of some
>> administrative software I'm writing for an educational institution,
>> and the primary purpose of the gender column is to help the users
>> cope with a problem ne
Steve Crawford wrote:
Of course this breaks apart when dealing with that very rare syndrome
(name escapes me) where the child appears female at birth but is
actually a male whose male sex-organs descend and appear at puberty
so I
guess we need to add apparent_sex_at_birth.
It turns out ther
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)
> > 1Male
> > 2Female
> > 3Trans
> > \.
>
>
> Not to take this completely off track, but isn't transgendered n
On 8 Dec 2006 at 12:17, Richard Troy wrote:
> Ray, darest I point out that that's never been possible in English
> anyway? There are dozens if not hundreds of androgenous names - Pat and
> Tracy come immediately to mind, and there are countless others!
You're correct, of course - but this is the
On Fri, 8 Dec 2006, Raymond O'Donnell wrote:
>
> Yes, the table is used only for humans; it's part of some
> administrative software I'm writing for an educational institution,
> and the primary purpose of the gender column is to help the users
> cope with a problem new to the west of Ireland -
On 8 Dec 2006 at 11:13, Scott Marlowe wrote:
> Male
> Female
> Hermaphrodite
> Trans (MTF)
> Trans (FTM)
> Neuter
>
> and... I can't think of a seventh possibility.
How about just plain confused??
--Ray.
--
Raymond O'Donnell
On 8 Dec 2006 at 15:12, Jorge Godoy wrote:
> I haven't read the beginning of the thread, but will this table be
> used only for humans? There are animals that are hermafrodites (I hope
Many thanks to all who responded - I had no idea of the monster I was
creating in starting this thread!
Yes,
Isn't that why we have null?
On Fri, 8 Dec 2006, Steve Wampler wrote:
Andreas Kretschmer wrote:
What about with Hermaphroditism?
More seriously - is the gender something you always know? There
are situations in the US where you cannot force someone to divulge
their gender. So you may need
On Fri, Dec 08, 2006 at 11:13:03AM -0600, Scott Marlowe wrote:
> On Fri, 2006-12-08 at 10:44, John Meyer wrote:
> > David Fetter wrote:
> > > On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
> > >> Just wondering.how do list member represent gender when storing
> > >> details
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 09:40, Leif B. Kristensen wrote:
> On Friday 8. December 2006 16:23, Raymond O'Donnell wrote:
>> Just wondering.how do list member represent gender when storing
>> details of people in a database?
>>
>> I've done it two ways:
>>
>> * A
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 09:31, John Meyer wrote:
> Second method might be better.
Too much heat from declaring "Males are True, Females are False"?
> Of course, you could also do a one chracter gender "M/F" if you want to
> save space.
>
> Raymond O'Donnell wro
Scott Marlowe wrote:
> On Fri, 2006-12-08 at 10:44, John Meyer wrote:
>> David Fetter wrote:
>>> On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
>>> I usually use a tabl
Jorge Godoy wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
Yes, but further I don't know of any country that recognizes anything
but Male or Female.
I haven't read the beginning of the thread, but will this table be used only
for humans? There are animals that are hermafrodites (I hope
That not including Genetics,
where and individual could have
multiple X Chromomes individuals
Or be XY - female times those other
6 (or 7).
- Original Message -
From: "brian" <[EMAIL PROTECTED]>
To:
Sent: Friday, December 08, 2006 9:19 AM
Subject: Re: [GENERAL] Male/
I guess in the end it really depends on what the client wants to track
and what they don't. But this does actually have a serious implication,
and that is how do you code for something that is mutable vs. something
that supposedly is or very nearly immutable (i.e. the alphabet).
-
Scott Marlowe wrote:
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
David Fetter wrote:
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I usually use a table called gend
Scott Marlowe wrote:
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
David Fetter wrote:
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I usually use
Joshua D. Drake wrote:
On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
COPY gender (gender_pk, gender) FROM stdin;
0(unknown)
1Male
2Female
3Trans
\.
Not to take this completely off track, but isn't transgendered not so
much a gender as it is a process of moving f
On Fri, 2006-12-08 at 11:05, Joshua D. Drake wrote:
> On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
> > > COPY gender (gender_pk, gender) FROM stdin;
> > > 0(unknown)
> > > 1Male
> > > 2Female
> > > 3Trans
> > > \.
> >
> >
> > Not to take this completely off track, but isn'
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
> David Fetter wrote:
> > On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
> >> Just wondering.how do list member represent gender when storing
> >> details of people in a database?
> >
> > I usually use a table called gender whi
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Yes, but further I don't know of any country that recognizes anything
> but Male or Female.
I haven't read the beginning of the thread, but will this table be used only
for humans? There are animals that are hermafrodites (I hope I got the
English
On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
> > COPY gender (gender_pk, gender) FROM stdin;
> > 0(unknown)
> > 1Male
> > 2Female
> > 3Trans
> > \.
>
>
> Not to take this completely off track, but isn't transgendered not so
> much a gender as it is a process of moving from
Seven genders? Even San Fransisco thinks that's over the top.
David Fetter wrote:
> On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
>> Just wondering.how do list member represent gender when storing
>> details of people in a database?
>
> I usually use a table called gender
Andreas Kretschmer wrote:
> What about with Hermaphroditism?
More seriously - is the gender something you always know? There
are situations in the US where you cannot force someone to divulge
their gender. So you may need an 'unreported' value of some sort.
--
Steve Wampler -- [EMAIL PROTECTE
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
> Just wondering.how do list member represent gender when storing
> details of people in a database?
I usually use a table called gender which has one TEXT column, that
being its primary key. For one client I had, there were s
> COPY gender (gender_pk, gender) FROM stdin;
> 0(unknown)
> 1Male
> 2Female
> 3Trans
> \.
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?
---(end of broadcast)---
On Friday 8. December 2006 16:23, Raymond O'Donnell wrote:
>Just wondering.how do list member represent gender when storing
>details of people in a database?
>
>I've done it two ways:
>
>* A bool column, with the understanding that true/false represents
>one gender or the other.
>
>* Create a d
Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I've done it two ways:
* A bool column, with the understanding that true/false represents
one gender or the other.
* Create a domain, something like:
CREATE DOMAIN g
Raymond O'Donnell <[EMAIL PROTECTED]> schrieb:
> Just wondering.how do list member represent gender when storing
> details of people in a database?
>
> I've done it two ways:
>
> * A bool column, with the understanding that true/false represents
> one gender or the other.
>
> * Create a d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 09:23, Raymond O'Donnell wrote:
> Just wondering.how do list member represent gender when storing
> details of people in a database?
>
> I've done it two ways:
>
> * A bool column, with the understanding that true/false represents
>
Second method might be better.
Of course, you could also do a one chracter gender "M/F" if you want to
save space.
Raymond O'Donnell wrote:
> Just wondering.how do list member represent gender when storing
> details of people in a database?
>
> I've done it two ways:
>
> * A bool column, w
35 matches
Mail list logo
