Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 4ABCB9FB303;
	Sat, 31 Mar 2007 04:43:51 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 29824-06; Sat, 31 Mar 2007 04:43:59 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from bay0-omc3-s2.bay0.hotmail.com (bay0-omc3-s2.bay0.hotmail.com
	[65.54.246.202])
	by postgresql.org (Postfix) with ESMTP id A7C299FB2FD;
	Sat, 31 Mar 2007 04:43:45 -0300 (ADT)
Received: from BAY131-W3 ([65.55.136.38]) by bay0-omc3-s2.bay0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.2668);
	Sat, 31 Mar 2007 00:43:44 -0700
Message-ID: <BAY131-W33EEDD194983C9790C659B0620@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_c29f5318-d02b-4969-b14a-a0df408349aa_"
X-Originating-IP: [67.169.184.232]
From: Karthikeyan Sundaram <skarthi98@hotmail.com>
To: <pgsql-admin@postgresql.org>, <pgsql-sql@postgresql.org>
Subject: plpgsql function return array
Date: Sat, 31 Mar 2007 00:43:44 -0700
Importance: Normal
MIME-Version: 1.0
X-OriginalArrivalTime: 31 Mar 2007 07:43:44.0473 (UTC)
	FILETIME=[4F216490:01C77368]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.743 tagged_above=0 required=5 tests=AWL=-0.921,
	BAYES_20=-0.74, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708,
	HTML_40_50=0.496, HTML_MESSAGE=0.001, SPF_PASS=-0.001
X-Spam-Level: 
X-Archive-Number: 200703/240
X-Sequence-Number: 25064

--_c29f5318-d02b-4969-b14a-a0df408349aa_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hi,     I am using Postgres 8.1.0.  I have a requirement. I will create a f=
unction accepting few parameters.  This will check into various tables and =
give back an array of values.  I want to use the pgpsql block.  I know that=
 we can create using language sql.      Is it possible to return an array f=
rom the function?  Please guide me.  Regardsskarthi
_________________________________________________________________
Take a break and play crossword puzzles - FREE!
http://games.msn.com/en/flexicon/default.htm?icid=3Dflexicon_ wlmemailtagli=
nemarch07=

--_c29f5318-d02b-4969-b14a-a0df408349aa_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body>
Hi,<BR>&nbsp;<BR>&nbsp;&nbsp;&nbsp; I am using Postgres 8.1.0.&nbsp; I have=
 a requirement. I will create a function accepting few parameters.&nbsp; Th=
is will check into various tables and give back an array of values.&nbsp; I=
 want to use the pgpsql&nbsp;block.&nbsp; I know that we can create using l=
anguage sql. <BR>&nbsp;<BR>&nbsp;&nbsp;&nbsp; Is it possible to return an a=
rray from the function?&nbsp; Please guide me.<BR>&nbsp;<BR>&nbsp;<BR>Regar=
ds<BR>skarthi<BR><BR><br /><hr />Take a break and play crossword puzzles - =
FREE! <a href=3D'http://games.msn.com/en/flexicon/default.htm?icid=3Dflexic=
on_ wlmemailtaglinemarch07 ' target=3D'_new'>Play Now!</a></body>
</html>=

--_c29f5318-d02b-4969-b14a-a0df408349aa_--