· 6 years ago · Mar 20, 2019, 03:50 AM
1CREATE TABLE transactions
2(
3 transacted_at TIMESTAMP
4);
5
6CREATE INDEX IF NOT EXISTS index_transactions_on_transacted_at
7 ON transactions (transacted_at);
8
9SELECT * FROM transactions
10WHERE tsrange('2018-01-01', NULL) @> transacted_at;
11
12SELECT * FROM transactions
13WHERE transacted_at > '2018-02-01'