Re: [R] RSQLite: rounding

2016-02-24 Thread Leonardo Miceli
Hi Sarah I didn't know the function dput! I checked the formatting issue by doing simple arithmetic operations on the data. But with the dput function these issue turned much more clear. Here goes the result... I just change the "head" by the "tail" function, so we must have exactly the same dat

Re: [R] RSQLite: rounding

2016-02-24 Thread Sarah Goslee
How did you "check it out"? I still suspect a formatting issue. Please use dput() to provide a bit of data from each, eg dput(head(x1)) dput(head(x2)) Sarah On Tue, Feb 23, 2016 at 5:31 PM, Leonardo Miceli wrote: > > Does anybody here had any problem with rounding using RSQLite? > > I have a qu

[R] RSQLite: rounding

2016-02-24 Thread Leonardo Miceli
Does anybody here had any problem with rounding using RSQLite? I have a query which return around 100 thousands records of double precision numeric values. The query returns the numbers with 1 digit precision. But when I run the same query but constrains the number of recorded values returned,