2018-03-15 22:13 GMT+01:00 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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
>