pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.




view thread (2+ messages)  latest in thread

Message-ID: <111F528ABE61D511BD3C0050DA5CA0A2C5FC@JAGUAR>
Permalink:  ../111F528ABE61D511BD3C0050DA5CA0A2C5FC@JAGUAR/
Also on:    postgresql.org/message-id/111F528ABE61D511BD3C0050DA5CA0A2C5FC@JAGUAR

 · 

reply

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