On Aug 31, 2013, at 6:42 PM, James K. Lowden <[email protected]> wrote:
> I changed the data (see below) because *meaning* of recordings.ends > should be an "exclusive end", what's knows as a half-open interval. > That makes the question of "does b follow a" one of equality. It is > likely not the case that exactly one second transpires between two > files. Rather, there is *no* time between them, implying that the end > time is at the "end of that second". Much easier to think of both as > being the beginning of the second. Meant to ask you about that… is it really worthwhile the overall complication? That half-open interval business that is? After all, the idiomatic way to query point in time data would be using 'between', no? For example: where point_in_time between valid_from and valid_to As oppose to: where point_in_time >= valid_from and point_in_time < valid_to Thoughts? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
