Re: Precision when substracting two values with SQL

On Mon, Aug 12, 2002 at 04:57:32PM -0300, Juancho wrote:
>
> ciudadela=# select 0.2-0.21;
>        ?column?
> ----------------------
>  -0.00999999999999998
> (1 row)
>
>     I was hoping -0.01,

Try

select (0.2-0.21)::numeric(12,2);

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110