Postgres Pro
Downloads
Home   >   mailing lists

Re: Precision when substracting two values with SQL - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: Precision when substracting two values with SQL
Date
Msg-id 20020812162742.Z17166@mail.libertyrms.com
Whole thread Raw
In response to Precision when substracting two values with SQL  (Juancho <squid@maxiconsumo.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Precision when substracting two values with SQL
Next
From: Juancho
Date:
Subject: Re: Precision when substracting two values with SQL