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
-----------137462096137462096
(2 rows)
please let me know what is the alternative and if possible with a sample
piece of code.
cheers
chowdary.