On Fri, Aug 5, 2011 at 7:32 AM, Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote: > If you want to avoid your problem, switch to NUMERIC(precision, scale), which is precise data type. > Alter the type of your "double" columns. > I'd suggest NUMERIC without specifying precision or scale. That gives you the most flexibility. I would only specify precision and scale if these are to be enforced on data input. Best Wishes, Chris Travers -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
