That's a bit disingenuous, Hadley. There have been reports of problems with POSIXct and ggplot2 for at least six months, particularly with values that have no time portion. You have promised a fix before, but l haven't seen it, so I convert to Date to work around the bug.
"Hadley Wickham" <had...@rice.edu> wrote: >Hi Ottar, > >It's impossible to tell what the problem is without a reproducible >example (http://gist.github.com/270442) > >Hadley > >On Sun, Jun 20, 2010 at 4:38 PM, Ottar Kvindesland ><ottar.kvindesl...@gmail.com> wrote: >> I have a problem that puzzles me a bit today. When loading off data from a >> database and plotting using ggplot2, I wish to present data as a time series >> with time of day. The code is text-book like as shown below: >> >> # Fetch data >> con <- dbConnect(dbDriver("MySQL"), user="user", password = "pwd", >> dbname="db") >> data <- dbGetQuery(con, "select PU, DateTime from rep;") >> data$time <- as.POSIXct(data$DateTime) >> attach(data) >> >> # Plot Data >> p <- ggplot(data, aes(x=time, colour=PU ) ) + >> ylim( c(0, max(PU)) ) + >> geom_line( aes(x=time, PU ) ) >> >> p >> >> It starts plotting and terminates before anything is drawn on the canvas. >> The error message on the terminal is: >> >> Error in seq.int(0, to - from, by) : 'to' must be finite >> >> The DateTime coloumn in MySQL is of type datetime Is it a bug or a feature? >> >> >> >> Thanks >> >> ottar >> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> R-help@r-project.org mailing list >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contained, reproducible code. >> > > > >-- >Assistant Professor / Dobelman Family Junior Chair >Department of Statistics / Rice University >http://had.co.nz/ > >______________________________________________ >R-help@r-project.org mailing list >https://stat.ethz.ch/mailman/listinfo/r-help >PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >and provide commented, minimal, self-contained, reproducible code. --------------------------------------------------------------------------- Jeff Newmiller The ..... ..... Go Live... DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --------------------------------------------------------------------------- Sent from my phone. Please excuse my brevity. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
