On Tue, Jun 1, 2010 at 9:24 AM, viras <viras(at)yandex(dot)ru> wrote:
> megafon=# \d aaa
> Table "public.aaa"
> Column | Type | Modifiers
> --------+------+-----------
> num | real |
>
> Yes, really, on smaller quantity of digits of errors is not present.
> What type of the data is better for using? Numbers up to 100000 and accuracy of 2 fractional signs.
numeric is a good choice to avoid loss of precision, but can be a bit slower.
You could also try float8.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company