Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of bchesneau@gmail.com designates
 209.85.216.178 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CABvT1DGkwc73AyMafgd2ubspxfEMk29zQSbyWHdm1WGsvcc=bQ@mail.gmail.com>
References: <kfvbob$c6p$1@ger.gmane.org>
	<kfvcjt$k97$1@ger.gmane.org>
	<CABvT1DFtvhBL7pbveHPK_b-cVsA++ria=MZBdw_GkjA4oMz2jQ@mail.gmail.com>
	<1CA1ECC0-5883-4714-9181-3E68B38FFAD6@couchbase.com>
	<CAJNb-9pduidsRrNVxGUHewvCaKC6m9PzRR82fKXz+vi_80qxYA@mail.gmail.com>
	<1F01C9AF-B216-465B-AD02-3752908CEE40@sri.com>
	<CABvT1DGkwc73AyMafgd2ubspxfEMk29zQSbyWHdm1WGsvcc=bQ@mail.gmail.com>
Date: Wed, 20 Feb 2013 12:14:35 +0100
Message-ID: 
 <CAJNb-9pP9OrdAOvEzQPV0_EyydyCXL-R1ZaQnZVFa7AjmWXYdQ@mail.gmail.com>
Subject: Re: Fixed precision of floating point number not respected in views
From: Benoit Chesneau <bchesneau@gmail.com>
To: "user@couchdb.apache.org" <user@couchdb.apache.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Wed, Feb 20, 2013 at 11:33 AM, Robert Newson <rnewson@apache.org> wrote:

> I think we've said this every way it can be said now.
>
About the maths and the json limits probably. But maybe as a *data*
storage we could offer a convenient way to maintain formats or data
types when a uploading a doc. I mean even if you have stored
-33.91017999999999688 in the db, if someone asking to have only 5
decimals then it will for sure become  -33.91018  in most of the maths
systems.

In short i'm currently asking if the db should offer such facility (I
find it interresting) of just let the app to do it. One good thing on
forcing it in the db level is that all the clients that would access
to this data will have the same result not depending on their own
library:


js> os =3D '{"a": -33.91018 }'
"{\"a\": -33.91018 }"
js> o =3D JSON.parse(os)
({a:-33.91018})
js> o.a
-33.91018

>>> os =3D '{"a": -33.91018 }'
>>> import json
>>> o =3D json.loads(os)
>>> o['a']
-33.91018


1> OS =3D << "{\"a\": -33.91018 } ">>
1> .
<<"{\"a\": -33.91018 } ">>
2> jiffy:decode(OS).
{[{<<"a">>,-33.91018}]}


- beno=EEt