Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group