From: Sandeep Chibber <sandeep@vreach.net>
To: pgsql-sql@postgresql.org
Subject: Problem with the result set of postgres
Date: Mon, 27 May 2002 12:52:47 +0530
Message-ID: <000f01c2054f$4d79ac10$1302a8c2@multicast.com> (raw)
Hi
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()
The output is 168269272 ,
in this table there are two records and the output is also coming twice There is no change in the number 168269272 ,168269272
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 function call will come from the java bean.
2. The table will have different datatypes.
Thanks
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sandeep@vreach.net
Subject: Re: Problem with the result set of postgres
In-Reply-To: <000f01c2054f$4d79ac10$1302a8c2@multicast.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox