[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