On Sep 29, 2010, at 7:05 PM, Simon Slavin wrote: > SQL (not just SQLite) is traditionally terribly bad at doing matrix > inversions. What do you want to use the wide short table for ? Does it > really need to exist as a table ?
Just for fun (and profit): http://www.orafaq.com/wiki/PIVOT http://www.orafaq.com/wiki/UNPIVOT _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users