pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Nielsen <python@kepnet.net>
To: pgsql-sql@postgresql.org
Subject: How do I return more than one value in a postgresql pl/pgsql procedure?
Date: Fri, 22 Feb 2002 12:56:53 -0500
Message-ID: <3C768665.30500@kepnet.net> (raw)

Hello!

I am have been trying to figure out how I can get a pl/pgsql procedure 
to return more than one variable or perhaps a row. A procedure you 
create can accept more than one variable, I don't see why it shoudn't be 
able to return more than one variable in some fashion.I read rumors that 
  pl/pgsql can return rows (which would contain one or more variables 
per row), but I didn't find hard examples of how to do it.

What table lists the stored procedures you created with pl/pgsql or 
pl/perl? I was trying to find it with /dS in psql, but I didn't see 
anything obvious.
Thanks!
Mark




view thread (2+ messages)  latest in thread

Message-ID: <3C768665.30500@kepnet.net>
Permalink:  ../3C768665.30500@kepnet.net/
Also on:    postgresql.org/message-id/3C768665.30500@kepnet.net

 · 

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: python@kepnet.net
  Subject: Re: How do I return more than one value in a postgresql pl/pgsql procedure?
  In-Reply-To: <3C768665.30500@kepnet.net>

* 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