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?.
typname | typnamespace | typdefaultbin | typdefault |
---|---|---|---|
time_stamp | information_schema | {FUNCEXPR :funcid 1967 :funcresulttype 1184 :funcretset false :funcvariadic false :funcformat 1 :funccollid 0 :inputcollid 0 :args ({COERCEVIAIO :arg {CONST :consttype 25 :consttypmod -1 :constcollid 100 :constlen -1 :constbyval false :constisnull false :location -1 :constvalue 7 [ 28 0 0 0 110 111 119 ]} :resulttype 1184 :resultcollid 0 :coerceformat 2 :location 105} {CONST :consttype 23 :consttypmod -1 :constcollid 0 :constlen 4 :constbyval true :constisnull false :location -1 :constvalue 4 [ 2 0 0 0 0 0 0 0 ]}) :location 105} | ('now'::text)::timestamp(2) with time zone |
SELECT 1
CREATE TABLE
id | col_without_default | col_with_default |
---|---|---|
1 | X | null |
INSERT 0 1
id | col_without_default | col_with_default |
---|---|---|
1 | 2023-03-31 06:51:37.11+00 | null |
INSERT 0 1