=> => I need to add a column for "release #" in one of my tables. A => numeric(3) would be plenty, but I wonder if I shouldn't just => make it an integer and be done with it. I don't expect the => field to be indexed, so I guess this is just silliness over => 1 byte, eh? => => Can anyone name a valid reason why you'd make it INTEGER => type instead of NUMERIC(3)? => => tia! => --Michael =>
Aside from the fact that there is no such thing as numeric(3), but rather numeric (3,0), the time and effor that you have spent even thinking about this will not be recovered unless your program is run 13 trillion times an hour for 137 trillion hours over the next month. Whenever I have such anomalous doubts, I always choose bifurcatied split-infinitive mantissa encoding. Nevertheless, even this approach is uncharacteristic. B+ HALinNY _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
