Postgres 14

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

-- plpgsql function
create or replace function increment(i integer) returns integer AS $$
        begin
                return i + 1;
        end;
$$ language plpgsql;


-- example to fail
do $$
declare
  test_result integer;
begin
  select increment(1)
  into test_result;

  assert test_result = 1, 'Wrong increment added';
end$$;
ERROR:  Wrong increment added
CONTEXT:  PL/pgSQL function inline_code_block line 8 at ASSERT


-- test to pass
do $$
declare
  test_result integer;
begin
  select increment(1)
  into test_result;

  assert test_result = 2, 'Wrong increment added';
end$$;