On Tue, Jun 1, 2010 at 9:24 AM, viras <vi...@yandex.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs