help..postgresql mulyiple return values - Mailing list pgsql-sql

From Michael Joseph Tan
Subject help..postgresql mulyiple return values
Date
Msg-id 20060512103804.82877.qmail@web50105.mail.yahoo.com
Whole thread Raw
Responses Re: help..postgresql mulyiple return values
List pgsql-sql
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.

pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: Add column and specify the column position in a table
Next
From: filippo2991@virgilio.it
Date:
Subject: insert related data into two tables