add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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