Postgres Pro
Downloads
Home   >   mailing lists

Re: How to cast to regprocedure with OUT parameters - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: How to cast to regprocedure with OUT parameters
Date
Msg-id lsilse$rbv$1@ger.gmane.org
Whole thread Raw
In response to Re: How to cast to regprocedure with OUT parameters  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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
SQLWorkbench/J 

Thanks for the quick reply
Thomas

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to cast to regprocedure with OUT parameters
Next
From: Si Chen
Date:
Subject: is there a way log last query in pg_stat_activity