Re: [GENERAL] Reading an OUT parameter out of a function call

2013-02-25 Thread Stefan Keller
Thank you Keane and all. That works for me too. Yours, Stefan 2013/2/25 Russell Keane : >> > 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 thoug

Re: [GENERAL] Reading an OUT parameter out of a function call

2013-02-25 Thread Russell Keane
> > 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

Re: [GENERAL] Reading an OUT parameter out of a function call

2013-02-25 Thread Adrian Klaver
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 funct

Re: [GENERAL] Reading an OUT parameter out of a function call

2013-02-25 Thread Pavel Stehule
Hello 2013/2/25 Stefan Keller : > 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 ano

Re: [GENERAL] Reading an OUT parameter out of a function call

2013-02-25 Thread Merlin Moncure
On Mon, Feb 25, 2013 at 11: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()).m