Postgres 15

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

select version();


version


PostgreSQL 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit



SELECT 1


CREATE PROCEDURE swap_nums(INOUT arg_left INT, INOUT arg_right INT) LANGUAGE plpgsql AS
$plpgsql$
DECLARE
  temp_num INT = arg_left;
BEGIN
  arg_left = arg_right;
  arg_right = temp_num;
END;
$plpgsql$;

CREATE PROCEDURE


DO $plpgsql$
  DECLARE
    num1 CONSTANT INT NOT NULL = 10;
    num2 CONSTANT INT NOT NULL = 20;
  BEGIN
    RAISE NOTICE 'Before swap: num1=%, num2=%', num1, num2;
    CALL swap_nums(num1, num2); -- note CONSTANT variables can be altered via OUT params!
    RAISE NOTICE 'After  swap: num1=%, num2=%', num1, num2;
  END;
$plpgsql$;

ERROR:  variable "num1" is declared CONSTANT
CONTEXT:  PL/pgSQL function inline_code_block line 7 at CALL