[R] sqldf + Date class. Ordering and summary statistics appear to be incorrect.

2012-01-22 Thread Grant Farnsworth
I've been using sqldf heavily lately but have encountered problems with ordering of observations or calculating statistics such as max() and min() when the variable used is of class Date. For example, if I run the following code: === begin code = library(sqldf)

Re: [R] sqldf + Date class. Ordering and summary statistics appear to be incorrect.

2012-01-22 Thread Grant Farnsworth
On Mon, Jan 23, 2012 at 12:46 AM, Gabor Grothendieck ggrothendi...@gmail.com wrote: On Sun, Jan 22, 2012 at 10:59 PM, Grant Farnsworth gvfa...@gmail.com wrote: I've been using sqldf heavily lately but have encountered problems with ordering of observations or calculating statistics such as max