From: srinivas <srinivaschowdary@essemm.co.in>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: how can i return multiple values from a function
Date: Tue, 25 Sep 2001 17:05:39 +0530
Message-ID: <111F528ABE61D511BD3C0050DA5CA0A2C5FC@JAGUAR> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: srinivaschowdary@essemm.co.in
Subject: Re: how can i return multiple values from a function
In-Reply-To: <111F528ABE61D511BD3C0050DA5CA0A2C5FC@JAGUAR>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox