2018-03-16 8:43 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:2018-03-15 22:13 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:Hicreate 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: 107LOCATION: ExecInitExprRec, execExpr.c:2114Defaults 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 PROCEDUREpostgres=# call foo1(10,20);NOTICE: 00000: a: 10, b: 20, c: -778600432LOCATION: exec_stmt_raise, pl_exec.c:3643CALLattached patch fixes itRegardsPavel
2018-03-15 22:13 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:Hicreate 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: 107LOCATION: ExecInitExprRec, execExpr.c:2114Defaults 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 PROCEDUREpostgres=# call foo1(10,20);NOTICE: 00000: a: 10, b: 20, c: -778600432LOCATION: exec_stmt_raise, pl_exec.c:3643CALL
Hicreate 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: 107LOCATION: ExecInitExprRec, execExpr.c:2114
RegardsPavel
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных
