Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 11.22 (Debian 11.22-10.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit

SELECT 1

create table note (msg text);

-- CREATE PROCEDURE arrived in PostgreSQL 11
create procedure add_note(t text) language sql as $$
  insert into note values (t);
$$;

CREATE TABLE

CREATE PROCEDURE

call add_note('hello');
call add_note('again');

CALL

CALL

select msg from note;

msg

hello

again

SELECT 2