Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 6E1D79FB2D9
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Sat,  3 Mar 2007 18:09:02 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 33587-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Sat,  3 Mar 2007 18:08:49 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from web55602.mail.re4.yahoo.com (web55602.mail.re4.yahoo.com
	[206.190.58.226])
	by postgresql.org (Postfix) with SMTP id 91E5F9FB2D0
	for <pgsql-sql@postgresql.org>; Sat,  3 Mar 2007 18:08:58 -0400 (AST)
Received: (qmail 56867 invoked by uid 60001); 3 Mar 2007 22:08:57 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.mx;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=L+A4lbCFNdFrBHXHuYwTpqsWlYgItPzOXOSJHJF4EX561uwvsg7CV1JD5A3nE2xwJKdZPP4HYKhKaNCa/99+yL2mxUXL9zLMo95XTrJ1dhADR5dOqCqwXB/Wq8yVnXD0pqoQs7YFdq8AIdYT5RcAbhRxrsuVNvnY3xbJEiQL0Vc=;
X-YMail-OSG: 
 xgjCmtEVM1lbeNqNaR_3rV7awK5H6PuFlxwhdwpzztUyQKLYKidy7wDBFi3iVXj2yTqh7Ps1UK6MGMOWh0gwDs13OW3h.mujk9Jo3dXg6c9plZGbcZOXa_Zlsz_NUDBOezrAFj1oprM3HQ90aKCJOYbi
Received: from [165.98.140.116] by web55602.mail.re4.yahoo.com via HTTP;
	Sat, 03 Mar 2007 14:08:57 PST
X-Mailer: YahooMailRC/468 YahooMailWebService/0.6.132.8
Date: Sat, 3 Mar 2007 14:08:57 -0800 (PST)
From: Eugenio Flores <eflores767003@yahoo.com.mx>
Subject: How to return a select query
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1963988450-1172959737=:50573"
Message-ID: <213647.50573.qm@web55602.mail.re4.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.45 tagged_above=0 required=5 tests=AWL, BAYES_50,
	HTML_40_50, HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200703/22
X-Sequence-Number: 27660

--0-1963988450-1172959737=:50573
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hello. I would like to know how can I return a select expresion, and stored=
 in a variable, as cursors, but without the need of  fetching it, and just =
to get the hole resultset.=0A=0AFor example. I want to get this query: Sele=
ct * from table1, and stored in a variable that I can return to, like a row=
type variable. =0A=0AWhat I want is to call this function from a client apl=
ication and show the result in a table. Like a JTable in java. =0A=0AThanks=
 in advance for your help.=0A=0AGreetings.=0A=0A=0A=09=0A=09=0A=09=09=0A___=
________________________________________________________ =0ADo You Yahoo!? =
=0ALa mejor conexi=F3n a Internet y <b >2GB</b> extra a tu correo por $100 =
al mes. http://net.yahoo.com.mx =0A
--0-1963988450-1172959737=:50573
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:times new roman, new york, times, serif;=
font-size:12pt"><DIV>Hello. I would like to know how can I return a select =
expresion, and stored in a variable, as cursors, but without the need of&nb=
sp; fetching it, and just to get the hole resultset.</DIV>=0A<DIV>&nbsp;</D=
IV>=0A<DIV>For example. I want to get this query: Select * from table1, and=
 stored in a variable that I can return to, like a rowtype variable.&nbsp;<=
/DIV>=0A<DIV>&nbsp;</DIV>=0A<DIV>What I want is to call this function from =
a client aplication and show the result in a table. Like a JTable in java. =
</DIV>=0A<DIV>&nbsp;</DIV>=0A<DIV>Thanks in advance for your help.</DIV>=0A=
<DIV>&nbsp;</DIV>=0A<DIV>Greetings.</DIV>=0A<DIV>&nbsp;</DIV>=0A<DIV>&nbsp;=
</DIV></div><br>=0A=09=09<hr size=3D1>  =0ADo You Yahoo!? =0ALa mejor conex=
i=F3n a Internet y <b>2GB</b> extra a tu correo por $100 al mes. <a href=3D=
"http://net.yahoo.com.mx">http://net.yahoo.com.mx</a> =0A</body></html>
--0-1963988450-1172959737=:50573--