about summary refs log tree commit diff
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2020-07-07 13:31:58 -0400
committerJune McEnroe <june@causal.agency>2020-07-07 13:31:58 -0400
commit499a136441e41a3ab046d43bc8a925d9f10a479a (patch)
tree5749191846c8554a8dc505b4107b2e6f80943b78
parentOnly join FTS table when FTS query is present (diff)
downloadlitterbox-499a136441e41a3ab046d43bc8a925d9f10a479a.tar.gz
litterbox-499a136441e41a3ab046d43bc8a925d9f10a479a.zip
Use >= and < on events.time for -D
This will enable the use of an index on events.time.
-rw-r--r--scoop.c3
1 files changed, 2 insertions, 1 deletions
diff --git a/scoop.c b/scoop.c
index f49f09a..9605530 100644
--- a/scoop.c
+++ b/scoop.c
@@ -402,7 +402,8 @@ int main(int argc, char *argv[]) {
 	for (int opt; 0 < (opt = getopt(argc, argv, Opts));) {
 		switch (opt) {
 			break; case 'D': {
-				append(where, SQL(AND date(events.time) = date(:date)));
+				append(where, SQL(AND events.time >= date(:date)));
+				append(where, SQL(AND events.time < date(:date, '+1 day')));
 				binds[n++] = Bind(":date", optarg, 0);
 			}
 			break; case 'F': {