On 3/5/18 11:00, Pavel Stehule wrote: > I am looking on attached code, and it looks pretty well. Can be really > nice if this code will be part of release 11, because it is very > interesting, important feature feature.
Here is an updated patch, rebased on top of several recent changes, also added more documentation and tests in other PLs. > p.s. can be nice, if we allow same trick with calling of OUT variables > functions in plpgsql > > fx(in a, out x, out y) return int -- but requires some special mark > > do $$ > declare x int, y int, z int; > begin > z := fx(10, x, y); > raise notice '% .... > > Then migration from Oracle can be really easy and friendly
This would require some changes to how routines are looked up, because we currently ignore OUT parameters there. That code does not exist yet. But it's certainly a plausible extension for the future.
sure - this is topic for 12 release. But it can fix more than one issue when PL/SQL code is migrated.
note: in this case we should to return one parameter more. Out parameters + RETURN expression result.
-- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services