Postgres 16

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 PROCEDURE balance_change(varchar, numeric)
  LANGUAGE plpgsql AS
$proc$
BEGIN
  NULL;  -- dummy body
END
$proc$;

CREATE PROCEDURE


-- FAILS! (only "assignment" cast to numeric)
CALL balance_change('bla', float8 '123');

ERROR:  procedure balance_change(unknown, double precision) does not exist
LINE 2: CALL balance_change('bla', float8 '123');
             ^
HINT:  No procedure matches the given name and argument types. You might need to add explicit type casts.


-- exact type works, obviously
CALL balance_change('bla', numeric '123');

CALL


-- any integer type works ("implicit" cast)
CALL balance_change('bla', integer '123');

CALL


-- numeric literal works
CALL balance_change('bla', 123);

CALL


-- string literal works
CALL balance_change('bla', '123');

CALL