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?.
CREATe TABLe "OrDERS" ("orderdate" date, "food" varchar(40))
INSERT INTO "OrDERS" VALUES (CURRENT_DATE ,'Pasta'), (CURRENT_DATE + INTERVAL '1 day','Gnocci')
2 rows affected
SELECT to_char("orderdate",'Dy, Mon DD'), "food" FROM "OrDERS"
WHERE "orderdate" =
CASE WHEN NOW() < now()::date + interval '9h' THEN now()::date
ELSE now()::date + INTERVAL '1 day'
END
| to_char | food |
|---|---|
| Tue, Dec 22 | Gnocci |