hi Kevin, On 20 févr. 2014, at 14:11, Kevin Martin wrote:
> > 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 for you reply. In fact I would like the script to remain portable. I'm running all this on Mac OS X 10.6.8 (sqlite3 3.6.12) but I plan to share it and use it on FreeBSD too. And developing a extension is probably out of my reach :) Patrick _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
