Suppose I have a time series in a table such as time|value 0|... 1|... 2|... 5|... 7|...
where ... denotes some value. There are some missing values from the table, such as those corresponding to time=3,4,6 in my example. I need to insert the missing rows using 0 for the corresponding value. Is there a simple way to detect and insert missing rows like these for a large within sqlite, i.e., without writing a C/perl/etc. program? Regards, Luis _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
