By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
SELECT datemultirange '{[2021-01-01,2022-01-01)}'
- datemultirange '{[2021-03-01,2021-06-02]}';
| ?column? |
|---|
| {[2021-01-01,2021-03-01),[2021-06-03,2022-01-01)} |
SELECT 1
SELECT datemultirange '{[2021-01-01,2021-12-31]}'
- datemultirange '{[2021-03-01,2021-06-02], [2021-07-01,2021-12-30]}';
| ?column? |
|---|
| {[2021-01-01,2021-03-01),[2021-06-03,2021-07-01),[2021-12-31,2022-01-01)} |
SELECT 1