what datatype to use question

From: Jeff Kish <jeff.kish_at_mro.com>
Date: Tue, 08 Apr 2003 12:45:09 -0400
Message-ID: <55u59vcr07ftegmkmtmdpofeogflfm9mga@4ax.com>

Greetings.

What datatype should I specify for a column that is to hold image extents? The values can be for raster, pretty small or large integers, and for vectors they can be in ranges like the following:
(-21234.5768, 21234.5678)
(-0.00332, .14234)

etc.

I am guessing that as long as I can guarantee 6 or 7 decimal places of accuracy, and hold up to 7 or 8 digits to the left of the decimal place, I should be pretty safe, but I am unsure how to proceed, i.e.:

CREATE TABLE TESTDOUBLE (

  REALONE     REAL         , 
  DECIMALONE  DECIMAL      , 
  FLOATONE    FLOAT        , 
  NUMBERONE   NUMBER       

)
Are one of these recommended? I don't "think" I'll have to do where searches on the column, but I can't guarantee that it might happen in some obscure case.

Thanks for your recommendations.
Jeff Received on Tue Apr 08 2003 - 11:45:09 CDT