[Babase] lymphstates

Karl O. Pinc kop at meme.com
Wed Jul 21 16:46:03 EDT 2010


You know what?  This change does not make any sense.
The database will automatically convert '1' into
1, and vice versa, as needed.

On 07/21/2010 11:21:07 AM, Karl O. Pinc wrote:
> 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
> 
> 




Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein




More information about the Babase mailing list