Re: plpgsql out parameter with select into - Mailing list pgsql-sql

From Imre Horvath
Subject Re: plpgsql out parameter with select into
Date
Msg-id 1282143617.2734.2.camel@cytherian.blemidon.dyndns.org
Whole thread Raw
In response to Re: plpgsql out parameter with select into  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-sql
It don't work...       
Only select into status * from... works.       
Imre Horvath

2010. 08. 18, szerda keltezéssel 09.42-kor Sergey Konoplev ezt írta:
> Hi,
> 
> SELECT column_name
> INTO var_name
> FROM ...
> 
> 2010/8/17 Horváth Imre <horvath.imre@blemidon.hu>:
> > Hi!
> >
> > My question is, how can I get the out parameter from a function with
> > SELECT INTO by name?
> > I mean:
> >
> > create function testfunc1(OUT _status integer) returns integer as
> > $BODY$
> >        _status := 0;
> > $BODY$
> > language plpgsql;
> >
> > create function testfunc2() as
> > declare
> >        status integer;
> > $BODY$
> >        select into status * from testfunc1();
> > $BODY$
> > language plpgsql;
> >
> > create function testfunc3() as
> > declare
> >        status integer;
> > $BODY$
> >        select into status _status from testfunc1();
> > $BODY$
> > language plpgsql;
> >
> > testfunc2 works, testfunc3 not.
> >
> > Thanks in advance:
> > Imre Horvath
> >
> >
> > --
> > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-sql
> >
> 
> 
> 




pgsql-sql by date:

Previous
From: Horváth Imre
Date:
Subject: Re: plpgsql out parameter with select into
Next
From: Sergey Konoplev
Date:
Subject: Re: plpgsql out parameter with select into