[SQL] how can i return multiple values from a function

[srinivas]

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.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly