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
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