Tom Lane wrote on 14.08.2014 17:33:
Leave out the OUT parameters altogether:select pg_get_functiondef('public.foo(text, text)'::regprocedure); Only IN parameters contribute to the function's identity; OUT parameters are just a variant method of specifying its return type.
Ah, great. I didn't think of that.
Personally I wouldn't randomly mix IN and OUT like that, but put all the OUT parameters at the end of the list. It seems too confusing otherwise.
I agree ;) and I'm not creating functions like that. I'm just trying to tackle all possible combinations in order to reliably retrieve a functions source code in my tool SQL Workbench/J Thanks for the quick reply Thomas
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
