From: Tony Wasson <ajwasson@gmail.com>
To: Michael Joseph Tan <josephtan2k@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: help..postgresql mulyiple return values
Date: Thu, 18 May 2006 10:53:58 -0700
Message-ID: <6d8daee30605181053g29ffbeccy2f4e13b9aedccaf5@mail.gmail.com> (raw)
In-Reply-To: <20060512103804.82877.qmail@web50105.mail.yahoo.com>
References: <20060512103804.82877.qmail@web50105.mail.yahoo.com>
On 5/12/06, Michael Joseph Tan <josephtan2k@yahoo.com> wrote:
>
> hi,
> im new in postgresql, generally new in databases.
>
> im trying to make a function using PGAdminIII which returns several types,
> example, my query is:
>
> "select count(id) as requests, organization from connection_requests group
> by organization"
>
> id is of type int8, organization is of type varchar(50).
>
> basically the query would return coun(id), and a varchar(50) which is
> organization.
>
> i really dont know what to put on the return type.
>
> what would be the best solution?
If you are in 8.1 you can follow this example from the documentation.
http://www.postgresql.org/docs/8.1/interactive/plpgsql-declarations.html
CREATE FUNCTION sum_n_product(x int, y int, OUT sum int, OUT prod int) AS $$
BEGIN
sum := x + y;
prod := x * y;
END;
$$ LANGUAGE plpgsql;
Then run it like:
SELECT sum, prod FROM sum_n_product(1,2);
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: ajwasson@gmail.com, josephtan2k@yahoo.com
Subject: Re: help..postgresql mulyiple return values
In-Reply-To: <6d8daee30605181053g29ffbeccy2f4e13b9aedccaf5@mail.gmail.com>
* 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