Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 5CBF44759CC for ; Mon, 27 May 2002 03:25:38 -0400 (EDT) Received: from vreach.net (unknown [203.200.125.131]) by postgresql.org (Postfix) with ESMTP id 5098147596E for ; Mon, 27 May 2002 03:25:26 -0400 (EDT) Received: from lokhi [194.168.2.19] by vreach.mzi.net [194.168.2.30] with SMTP (MDaemon.PRO.v5.0.5.R) for ; Mon, 27 May 2002 13:00:30 +0530 Message-ID: <000f01c2054f$4d79ac10$1302a8c2@multicast.com> From: "Sandeep Chibber" To: Subject: Problem with the result set of postgres Date: Mon, 27 May 2002 12:52:47 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000C_01C2057D.67072E90" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-MDRemoteIP: 194.168.2.19 X-Return-Path: sandeep@vreach.net X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Archive-Number: 200205/284 X-Sequence-Number: 7919 This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C2057D.67072E90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi=20 I am listing out the problem I am facing while EXECUTING the function . create table newtest (name varchar(50), address varchar(50)) CREATE FUNCTION newtestfunc () RETURNS setof varchar AS 'SELECT name,address FROM newtest' LANGUAGE 'SQL'; select newtestfunc()=20 The output is 168269272 , in this table there are two records and the output is also coming twice The= re is no change in the number 168269272 ,168269272 =20 Please guide me how to get the result set through a java bean My Requirement : 1.I want to retrieve multiple records from the table using function. The fu= nction call will come from the java bean. 2. The table will have different datatypes. Thanks=20 ------=_NextPart_000_000C_01C2057D.67072E90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I am listing out the problem I am facing = while=20 EXECUTING the function .

create table newtest (name varchar(50), a= ddress=20 varchar(50))

CREATE FUNCTION newtestfunc () RETURNS se= tof=20 varchar AS
'SELECT name,address FROM newtest'
LANGUAGE 'SQL';<= /DIV>

select newtestfunc()=20

The output is 168269272 ,

in this table there are two records and t= he output=20 is also coming twice There is no change in the number 168269272=20 ,168269272

Please guide me how to get the resul= t=20 set through a java bean

My Requirement :

1.I want to retrieve multiple records from the tabl= e using=20 function. The function call will come from the java bean.

2. The table will have different datatypes.<= /DIV>

Thanks

------=_NextPart_000_000C_01C2057D.67072E90--