DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=OpS4F4KaY8A1JMGB778s5IMXHPkRgxK7Gt+IKVo7MnY1z+5NhfEAri0GYkPNvMRXzUsgHIFnLrG2axK/q0A3DQ7Eb9M9MCVsjURE79aCfYOZnfHMbYiCG0SqsCFTR7mMe/D4DrPXOhqNR6v74mh9qtIZABbGefMg+zeguB4ckas=
Message-ID: <ffac568905050507383026a00b@mail.gmail.com>
Date: Thu, 5 May 2005 15:38:29 +0100
From: =?ISO-8859-1?Q?Listas_Evandro_=28N=E3o_use_este_en?=
	=?ISO-8859-1?Q?dere=E7o_para_mensagens_pessoais=29?= <listasjr@gmail.com>
Reply-To: =?ISO-8859-1?Q?Listas_Evandro_=28N=E3o_use_este_en?=
	=?ISO-8859-1?Q?dere=E7o_para_mensagens_pessoais=29?=
	<listasjr@gmail.com>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Select of a function that returns a array
In-Reply-To: <ffac5689050505072721405cb4@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <ffac5689050505072721405cb4@mail.gmail.com>

Hi guys

I'm trying to figure out a way to make this select work even for a wrong va=
lue:

select mean_and_variancepop('golf', 'temperature');
or
select CAST (mean_and_variancepop('golf', 'temperature') AS float(2));

This function return an array

the function is:

CREATE or replace FUNCTION mean_and_variancepop(var_table varchar,
var_col varchar) RETURNS float(2) AS $$
DECLARE
   curs refcursor;
   a float;
   b float;
   c float;
   retvals float[2];
   sum float:=3D0;
BEGIN
   open curs FOR EXECUTE 'SELECT ' || quote_ident(var_col) || ' FROM
' || quote_ident(var_table);
   b:=3D0;

LOOP
  -- some computations
FETCH curs INTO a;

   IF  NOT FOUND THEN
       EXIT;  -- exit loop
   END IF;
   b:=3Db+1;
   c:=3Da;
   sum:=3D sum + c;
END LOOP;
   CLOSE curs;
   retvals[0]:=3D sum / b;
   retvals[1] :=3D4;
   RETURN retvals;

END;
$$ LANGUAGE plpgsql;

Thanks
-Jr