В сообщении от Tuesday 17 June 2008 20:59:19 Dennis Cote написал(а):
> I would recommend that you change your database schema an combine your
> timestamp string and subsecond integer field into a single floating
> point julian day number that provides both pieces of information in
> units of days (since the julian day epoch).
There is problem for select one row by time - we must use query
select * from events where time || =julianday('2008-06-16 23:59:59.999');
and index is not used for this query.
Maybe patch http://www.sqlite.org/cvstrac/chngview?cn=5215
resolved problem but I'm not sure.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
