Re: Floating point type to store numbers

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: radhika(at)88thstreet(dot)com, pgsql-sql(at)postgresql(dot)org
Subject: Re: Floating point type to store numbers
Date: 2007-04-17 19:18:16
Message-ID: 504276.57905.qm@web31804.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


---
> 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Radhika Sambamurti 2007-04-17 20:28:04 Re: Floating point type to store numbers
Previous Message Milen A. Radev 2007-04-17 19:10:40 Re: Floating point type to store numbers