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 1 WHERE 3 BETWEEN SYMMETRIC 1 AND 10;
-- 1
| ?column? |
|---|
| 1 |
SELECT 1
SELECT 1 WHERE 3 BETWEEN SYMMETRIC 10 AND 1
-- 1
| ?column? |
|---|
| 1 |
SELECT 1
SELECT 1 WHERE 3 BETWEEN 1 AND 10
-- 1
| ?column? |
|---|
| 1 |
SELECT 1
SELECT 1 WHERE 3 BETWEEN 10 AND 1
-- no rows
| ?column? |
|---|
SELECT 0
SELECT 1 WHERE 3 >= 1 AND 3 <= 10
-- 1
| ?column? |
|---|
| 1 |
SELECT 1
SELECT 1 WHERE 3 >= 10 AND 3 <= 1
-- no rows
| ?column? |
|---|
SELECT 0