Re: [SQL] help..postgresql mulyiple return values

2006-05-18 Thread Tony Wasson
On 5/12/06, Michael Joseph Tan <[EMAIL PROTECTED]> wrote: 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 organiz

[SQL] help..postgresql mulyiple return values

2006-05-17 Thread Michael Joseph Tan
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 ty