Postgres Pro
Downloads
Home   >   mailing lists

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

From Tim Ellis
Subject Re: Precision when substracting two values with SQL
Date
Msg-id 20020812132407.41c1b314.Tim.Ellis@gamet.com
Whole thread Raw
In response to Precision when substracting two values with SQL  (Juancho <squid@maxiconsumo.com>)
Responses Re: Precision when substracting two values with SQL  (Larry Rosenman <ler@lerctr.org>)
List pgsql-admin
Tree view 
> ciudadela=# select 0.2-0.2;
>         0
> ciudadela=# select 0.2-0.21;
>  -0.00999999999999998
> ciudadela=# select 0.21-0.22;
>     -0.01

I also get this on my Postgres 7.2.1, both Linux and Solaris.

--
Tim Ellis
Senior Database Architect
Gamet, Inc.

pgsql-admin by date:

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