diff options
| author | June McEnroe <june@causal.agency> | 2020-07-07 13:31:58 -0400 |
|---|---|---|
| committer | June McEnroe <june@causal.agency> | 2020-07-07 13:31:58 -0400 |
| commit | 499a136441e41a3ab046d43bc8a925d9f10a479a (patch) | |
| tree | 5749191846c8554a8dc505b4107b2e6f80943b78 | |
| parent | Only join FTS table when FTS query is present (diff) | |
| download | litterbox-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.c | 3 |
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': { |