On Fri, Aug 5, 2011 at 7:32 AM, Igor Neyman <ineyman(at)perceptron(dot)com> 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