help..postgresql mulyiple return values

Поиск
Список
Период
Сортировка
От Michael Joseph Tan
Тема help..postgresql mulyiple return values
Дата
Msg-id 20060512103804.82877.qmail@web50105.mail.yahoo.com
обсуждение исходный текст
Ответы Re: help..postgresql mulyiple return values  ("Tony Wasson" <ajwasson@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Emi Lu
Дата:
Сообщение: Add column and specify the column position in a table
Следующее
От: filippo2991@virgilio.it
Дата:
Сообщение: insert related data into two tables