2018-03-15 22:13 GMT+01:00 Pavel Stehule <pavel.steh...@gmail.com>: > Hi > > create or replace procedure proc2(in a int, in b int) > as $$ > begin > a := a * 10; > b := b * 10; > end; > $$ language plpgsql; > > postgres=# call proc2(a => 10,b => 20); > ERROR: XX000: unrecognized node type: 107 > LOCATION: ExecInitExprRec, execExpr.c:2114 >
Defaults are not supported too: postgres=# create or replace procedure foo1(a int, b int, c int default 10) as $$ begin raise notice 'a: %, b: %, c: %', a, b, c; end; $$ language plpgsql; CREATE PROCEDURE postgres=# call foo1(10,20); NOTICE: 00000: a: 10, b: 20, c: -778600432 LOCATION: exec_stmt_raise, pl_exec.c:3643 CALL > Regards > > Pavel >