X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id C50399F9C18
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 12 May 2006 07:38:13 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 16253-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 12 May 2006 07:38:05 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from web50105.mail.yahoo.com (web50105.mail.yahoo.com
	[206.190.38.33]) by postgresql.org (Postfix) with SMTP id ABBF59F9430
	for <pgsql-sql@postgresql.org>; Fri, 12 May 2006 07:38:05 -0300 (ADT)
Received: (qmail 82879 invoked by uid 60001); 12 May 2006 10:38:04 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=EZbvS53kYmHVjJlYzHAFJE9rNFhDWRJWNpURfrUV5wyziiJJRE7olVYTkwWNjrXhiAYhGw4PuVHs2HXGrfRviy4rOaW52yDnZ/kBIhO0RapVDaaKb/33hKOOrPK44W4T70EftwY4EbaWPdZ7nU9ev3Y5PF61AGrqcAOSdfMMMjw=
	;
Message-ID: <20060512103804.82877.qmail@web50105.mail.yahoo.com>
Received: from [202.164.181.114] by web50105.mail.yahoo.com via HTTP;
	Fri, 12 May 2006 03:38:04 PDT
Date: Fri, 12 May 2006 03:38:04 -0700 (PDT)
From: Michael Joseph Tan <josephtan2k@yahoo.com>
Subject: help..postgresql mulyiple return values
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-715679082-1147430284=:81008"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/123
X-Sequence-Number: 25154

--0-715679082-1147430284=:81008
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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.
--0-715679082-1147430284=:81008
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div>hi,</div>  <div>im new in postgresql, generally new in databases.</div>  <div>&nbsp;</div>  <div>im trying to make a function using PGAdminIII which returns several types, </div>  <div>example, my query is:</div>  <div>&nbsp;</div>  <div><STRONG>"select count(id) as requests, organization from connection_requests group by organization"</STRONG></div>  <div>&nbsp;</div>  <div>id is of type int8, organization is of type varchar(50).</div>  <div>&nbsp;</div>  <div>basically the query would return coun(id), and a varchar(50) which is organization.</div>  <div>&nbsp;</div>  <div>i really dont know what to put on the return type.</div>  <div>&nbsp;</div>  <div>what would be the best solution?</div>  <div>&nbsp;</div>  <div>hope to hear from you guys asap..</div>  <div>&nbsp;</div>  <div>thank you</div><p>
		<hr size=1>Yahoo! Messenger with Voice. <a href="http://us.rd.yahoo.com/mail_us/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com">Make PC-to-Phone Calls</a> to the US (and 30+ countries) for 2¢/min or less.
--0-715679082-1147430284=:81008--