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 version();
| version |
|---|
| PostgreSQL 16.0 (Debian 16.0-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit |
SELECT 1
CREATE TABLE test (ts, te)
AS VALUES ('2023-10-25 14:33:00'::TIMESTAMPTZ, '2023-10-25 15:56:00'::TIMESTAMPTZ);
SELECT 1
--
INSERT INTO test VALUES ('2023-10-25 14:33:00', '2023-10-25 15:56:00');
-- Coercion - great!
--
INSERT 0 1
SELECT * FROM test;
| ts | te |
|---|---|
| 2023-10-25 14:33:00+00 | 2023-10-25 15:56:00+00 |
| 2023-10-25 14:33:00+00 | 2023-10-25 15:56:00+00 |
SELECT 2
SELECT (ts, te)::TSTZRANGE FROM test;
ERROR: cannot cast type record to tstzrange LINE 1: SELECT (ts, te)::TSTZRANGE FROM test; ^
SELECT TSTZRANGE(ts, te) FROM test;
| tstzrange |
|---|
| ["2023-10-25 14:33:00+00","2023-10-25 15:56:00+00") |
| ["2023-10-25 14:33:00+00","2023-10-25 15:56:00+00") |
SELECT 2