X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 8DFFC552D4
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Fri,  4 Mar 2005 07:34:07 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 66134-07
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Fri,  4 Mar 2005 07:34:03 +0000 (GMT)
Received: from web61010.mail.yahoo.com (web61010.mail.yahoo.com
	[216.155.196.99])
	by svr1.postgresql.org (Postfix) with SMTP id 5B5D452A60
	for <pgsql-interfaces@postgresql.org>;
	Fri,  4 Mar 2005 07:34:02 +0000 (GMT)
Received: (qmail 39233 invoked by uid 60001); 4 Mar 2005 07:34:02 -0000
Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	b=TSEP6yNlV7fKXwl+t8q2/9Th0kDL4du6ESo9xJIexsl1zB8ePnmNkX2NlfTHapp/j38IZvR3x2nDHiZ27sSkhhjQcgTjdFNzkskzHyzYiNGG9rUB6S6N3duHDNku5lOpHwQ+I8zm/I8wS7b+wHemM/arpVFkQKFuFILHTLkc6+c=
	;
Message-ID: <20050304073402.39231.qmail@web61010.mail.yahoo.com>
Received: from [68.120.71.7] by web61010.mail.yahoo.com via HTTP;
	Thu, 03 Mar 2005 23:34:02 PST
Date: Thu, 3 Mar 2005 23:34:02 -0800 (PST)
From: b t <qtboyzz@yahoo.com>
Subject: how to parse an proargtypes array?
To: pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1607439953-1109921642=:38817"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.266 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_ABUSE, HTML_20_30, HTML_MESSAGE
X-Spam-Level: *
X-Archive-Number: 200503/6
X-Sequence-Number: 5335

--0-1607439953-1109921642=:38817
Content-Type: text/plain; charset=us-ascii

Hi, first off all thank to the people that took the time to reply to my message, 
Unfortunately I do have another question to ask:
 
I'm trying to find out all the argument type that a user-defined function required, I used this query, select proargtypes from pg_proc where proname = 'add_movie'; but it gives me an oidvector array 1043 23 1043 1043 1043 1015 1015 1015 1182 1015, is there a query to parse this and give me a list of type.
thanks
-brian


		
---------------------------------
Celebrate Yahoo!'s 10th Birthday! 
 Yahoo! Netrospective: 100 Moments of the Web 
--0-1607439953-1109921642=:38817
Content-Type: text/html; charset=us-ascii

<DIV>
<DIV>Hi, first off all thank to the people that took the time to reply to my message, </DIV>
<DIV>Unfortunately I do have another question to ask:</DIV>
<DIV>&nbsp;</DIV>
<DIV>I'm trying to find out all the argument type that a user-defined function required, I used this query, select proargtypes from pg_proc where proname = 'add_movie'; but it gives me an oidvector array 1043 23 1043 1043 1043 1015 1015 1015 1182 1015, is there a query to parse this and give me a list of type.</DIV>
<DIV>thanks</DIV>
<DIV>-brian</DIV></DIV><p>
		<hr size=1>Celebrate Yahoo!'s 10th Birthday! <br> 
<a href="http://birthday.yahoo.com/netrospective/">Yahoo! Netrospective: 100 Moments of the Web</a> 
--0-1607439953-1109921642=:38817--