Postgres 14

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 OR REPLACE PROCEDURE my_proc(int)
  LANGUAGE plpgsql AS
$proc$
BEGIN
   RAISE NOTICE 'PROCEDURE says hi! $1 was: %', $1;
END
$proc$;


CREATE OR REPLACE FUNCTION my_func(int)
  RETURNS void
  LANGUAGE plpgsql AS
$func$
BEGIN
   RAISE NOTICE 'FUNCTION says hi! $1 was: %', $1;
END
$func$;

CREATE PROCEDURE



CREATE FUNCTION


DO
$do$
BEGIN
   PERFORM my_func(33);
   CALL my_proc(66);
   EXECUTE format('CALL %I(66)', 'my_proc');
   EXECUTE format('SELECT %I(33)', 'my_func');
END
$do$

DO


DO
$do$
BEGIN
   CALL my_func(33);
END
$do$

ERROR:  my_func(integer) is not a procedure
LINE 1: CALL my_func(33)
             ^
HINT:  To call a function, use SELECT.
QUERY:  CALL my_func(33)
CONTEXT:  PL/pgSQL function inline_code_block line 3 at CALL


DO
$do$
BEGIN
   PERFORM my_proc(66);
END
$do$

ERROR:  my_proc(integer) is a procedure
LINE 1: SELECT my_proc(66)
               ^
HINT:  To call a procedure, use CALL.
QUERY:  SELECT my_proc(66)
CONTEXT:  PL/pgSQL function inline_code_block line 3 at PERFORM