--- > The question is: how accurate is floating point numbers in Postgres. We > are using 7.4 soon to be moving to 8.2. > I need the accuracy to about 6 decimal points. I have read that floating > points can convert to numbers in accurately.
http://www.postgresql.org/docs/8.2/interactive/datatype-numeric.html#DATATYPE-FLOAT I didn't see anything about numeric being a string type, http://www.postgresql.org/docs/8.2/interactive/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org