how can i return multiple values from a function - Mailing list pgsql-sql

From srinivas
Subject how can i return multiple values from a function
Date
Msg-id 111F528ABE61D511BD3C0050DA5CA0A2C5FC@JAGUAR
Whole thread Raw
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: domingo@dad-it.com (Domingo Alvarez Duarte)
Date:
Subject: A bug in triggers PG 7.1.3 or misunderstand ?
Next
From: "Robin's PG-SQL List"
Date:
Subject: Aggregate Aggravation