help..postgresql mulyiple return values

Поиск

Список

Период

Сортировка

От	Michael Joseph Tan
Тема	help..postgresql mulyiple return values
Дата	18 мая 2006 г. 02:53:08
Msg-id	20060512103804.82877.qmail@web50105.mail.yahoo.com обсуждение
Ответы	Re: help..postgresql mulyiple return values
Список	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 по дате отправления: