Reading an OUT parameter out of a function call

From: Stefan Keller <sfkeller(at)gmail(dot)com>
To: pgsql-general List <pgsql-general(at)postgresql(dot)org>
Subject: Reading an OUT parameter out of a function call
Date: 2013-02-25 17:22:02
Message-ID: CAFcOn2__Wx9z=KqTCTjpqtLx=FeWE5rxbqnC+ZvZF8-O=UwOOw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a simple void function:

CREATE OR REPLACE FUNCTION myfn(myparam OUT int)
AS $$
BEGIN
pnr := 1;
END;
$$ LANGUAGE plpgsql;

How do I access myparam?
I thought this should work with 9.1/9.2: SELECT (myfn()).myparam;
Or inside another function?

Yours, Stefan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2013-02-25 17:30:47 Re: Reading an OUT parameter out of a function call
Previous Message Tom Duffey 2013-02-25 14:08:57 Re: Floating point error