From: Michael Joseph Tan <josephtan2k@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: help..postgresql mulyiple return values
Date: Fri, 12 May 2006 03:38:04 -0700 (PDT)
Message-ID: <20060512103804.82877.qmail@web50105.mail.yahoo.com> (raw)
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?
hope to hear from you guys asap..
thank you
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less.
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: josephtan2k@yahoo.com
Subject: Re: help..postgresql mulyiple return values
In-Reply-To: <20060512103804.82877.qmail@web50105.mail.yahoo.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