Postgres 10

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 now() at time zone 'utc'

timezone

2024-10-07 18:58:52.210936

SELECT 1

select (now() at time zone 'utc') :: timestamp(3)

timezone

2024-10-07 18:58:52.212

SELECT 1

create table t ( createdDate TIMESTAMP)

CREATE TABLE

INSERT INTO t(createdDate) VALUES (now() at time zone 'utc');
INSERT INTO t(createdDate) VALUES ((now() at time zone 'utc') :: timestamp(3));

INSERT 0 1

INSERT 0 1

select * from t

createddate

2024-10-07 18:58:52.219162

2024-10-07 18:58:52.219

SELECT 2