On 20 Feb 2014, at 12:54, Patrick Proniewski <pat...@patpro.net> wrote:
> My problem is that my database holds too many different values for > ExposureTime, so the resulting plot is unreadable. I want to be able to "bin" > those values to create a proper histogram. It's not possible to "bin" string > values, because SQLite has no idea that "1/60" has nothing to do near > "1/6000". Are you able to use an extension? A custom collation on the ExposureTime column seems pretty simple (although not thought about it in detail). You should then be able to bin the values as they are. Thanks, Kevin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users