Re: Reading an OUT parameter out of a function call

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Stefan Keller <sfkeller(at)gmail(dot)com>
Cc: pgsql-general List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reading an OUT parameter out of a function call
Date: 2013-02-25 17:37:41
Message-ID: 512BA165.8010402@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/25/2013 09:22 AM, Stefan Keller wrote:
> 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?

You get the above to load?
I get:
ERROR: "pnr" is not a known variable
LINE 4: pnr := 1;

>
> Yours, Stefan
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Cavaliero 2013-02-25 18:22:54 Use, Set Catalog and JDBC questions
Previous Message Pavel Stehule 2013-02-25 17:34:09 Re: Reading an OUT parameter out of a function call