i have tried retrieving multiple values using setof function but i
couldnt solve it.when i am trying using setof iam getting this as
output.
1 CREATE FUNCTION hobbies (varchar) RETURNS SETOF bank
2 AS 'SELECT * FROM bank
3 '
4 LANGUAGE 'sql';
~
output:
select hobbies('srinivas') as col;
col
-----------
137462096
137462096
(2 rows)
please let me know what is the alternative and if possible with a sample
piece of code.
cheers
chowdary.