help..postgresql mulyiple return values

From: Michael Joseph Tan <josephtan2k(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: help..postgresql mulyiple return values
Date: 2006-05-12 10:38:04
Message-ID: 20060512103804.82877.qmail@web50105.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Emi Lu 2006-05-12 20:57:00 Re: R: Re: R: R: Re: schema inspection
Previous Message ogjunk-pgjedan 2006-05-11 18:46:59 Re: Help with a seq scan on multi-million row table