| 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: | Whole Thread | Raw Message | 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.
| 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 |