DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=sender:subject:from:to:disposition-notification-to:content-type
	:date:message-id:mime-version:x-mailer:content-transfer-encoding;
	b=smJ7scQTLsjEOdZsRpdZZ6o9eoBrckLF/ENixsGNW7E3OheAgzv22wm7uwOmTOC+WP
	l5vuFf/0A4eB+0PluT1ZG5baHREwp68ryQAOsSEYJn2Ez6eqW92wgERF1KaUzhT/wTLP
	lRCRr3LmAJOkrlwCrZEzb2ak+tJc5EY7f6v04=
Subject: plpgsql out parameter with select into
From: =?ISO-8859-1?Q?Horv=E1th?= Imre <horvath.imre@blemidon.hu>
To: pgsql-sql@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Date: Tue, 17 Aug 2010 20:45:09 +0200
Message-ID: <1282070709.3269.3.camel@cytherian.blemidon.dyndns.org>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

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