Home > mailing lists

Problem with the result set of postgres - Mailing list pgsql-sql

From	Sandeep Chibber
Subject	Problem with the result set of postgres
Date	May 27, 2002 20:26:28
Msg-id	000f01c2054f$4d79ac10$1302a8c2@multicast.com Whole thread Raw
List	pgsql-sql

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

From: "Julian Scarfe"
Date: 27 May 2002, 20:22:46
Subject: XSD to Postgresql SQL

From: "Michael Beckstette"
Date: 27 May 2002, 20:31:42
Subject: dynamic table names, determined by calling parameter