[Babase] lymphstates
Jeanne Altmann
altj at princeton.edu
Wed Jul 21 12:24:11 EDT 2010
Good, thanks.
jeanne
-----Original Message-----
From: babase-bounces at eeblistserv.princeton.edu
[mailto:babase-bounces at eeblistserv.princeton.edu] On Behalf Of Karl O.
Pinc
Sent: Wednesday, July 21, 2010 12:21 PM
To: The Baboon Database Project
Subject: Re: [Babase] lymphstates
On 07/21/2010 08:32:56 AM, Susan Alberts wrote:
> My only comment on this is that if the column is numeric but coded as
>
> a character it can be very confusing to query because it won't be
> natural or obvious that you need to query as a character, so I at any
>
> rate would often end up writing a query with this statement
>
> Select * from lymphstates
> where state = 1
>
> Instead of
>
> where state = '1'
> For
>
> this reason, if it's numeric it should be coded as numeric and if
> it's a character it would be better to have it as a letter. Does this
>
> make sense? I'm okay with either.
Ok. Makes sense. I'll make it numeric.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
_______________________________________________
Babase mailing list
Babase at www.eco.princeton.edu
http://www.eco.princeton.edu/mailman/listinfo/babase
More information about the Babase
mailing list