[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