> On Apr 7, 2015, at 5:53 PM, John McKown <john.archie.mckown at gmail.com> > wrote: > > I'm an idiot, thanks for not pointing that out. I thought I was on the > PostgreSQL forum and managed to mess up. My apologies to all.
We all have been there. I, for one, wish SQLite had some syntax sugar such as PIVOT/UNPIVOT: http://oracle-base.com/articles/11g/pivot-and-unpivot-operators-11gr1.php More handy than I care to admit :)
