Received: from jaguar.essemm.co.in ([212.162.196.74]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8PBWAh80525 for ; Tue, 25 Sep 2001 07:32:13 -0400 (EDT) (envelope-from srinivaschowdary@essemm.co.in) Received: by JAGUAR with Internet Mail Service (5.5.1960.3) id ; Tue, 25 Sep 2001 17:05:39 +0530 Message-ID: <111F528ABE61D511BD3C0050DA5CA0A2C5FC@JAGUAR> From: srinivas To: "'pgsql-sql@postgresql.org'" Subject: how can i return multiple values from a function Date: Tue, 25 Sep 2001 17:05:39 +0530 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.1960.3) Content-Type: text/plain X-Archive-Number: 200109/255 X-Sequence-Number: 4937 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.