[R-sig-DB] query result precision

[Kasper Daniel Hansen]

Are you sure that you do not get all the digits? Try
   print(fetch(rs, n = -1), digits = 15)

The default option of "digits" is 7 and it might hit you here.

Kasper

On May 11, 2008, at 8:15 PM, William Morris wrote:

> In R, using RSQLite, I get a maximum of 4 digits after the decimal  
> point for every value returned from a query, whereas the same select  
> statement executed with 'sqlite3' (at the command line) gives each  
> value without rounding. How can I get R to give the same output?
>
> Cheers in advance,
>
> Will.
>
> in R
>
> > m <- dbDriver("SQLite")
> > con <- dbConnect(m,"database.sqlite")
> > rs <- dbSendQuery(con,"select col1 from table1 limit 10")
> > fetch(rs,n=-1)
>   col1
> 1   145.0836
> 2   145.0836
> 3   145.0836
> 4   145.0836
> 5   145.0836
> 6   145.0836
> 7   144.0681
> 8   144.0681
> 9   144.0681
> 10  144.0681
>
> in sqlite3
>
> sqlite> select col1 from table1 limit 10;
> 145.08361
> 145.08361
> 145.08361
> 145.08361
> 145.08361
> 145.08361
> 144.06806
> 144.06806
> 144.06806
> 144.06806
>
> R session info
>
> sessionInfo()
> R version 2.7.0 Patched (2008-05-10 r45665)
> i386-apple-darwin8.10.1
>
> locale:
> en_AU.UTF-8/en_AU.UTF-8/C/C/en_AU.UTF-8/en_AU.UTF-8
>
> attached base packages:
> [1] stats     graphics  grDevices utils     datasets  methods   base
>
> other attached packages:
> [1] RSQLite_0.6-8 DBI_0.2-4
>
> loaded via a namespace (and not attached):
> [1] tools_2.7.0
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db