Skip site navigation (1) Skip section navigation (2)

how to parse an proargtypes array?

From: b t <qtboyzz(at)yahoo(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: how to parse an proargtypes array?
Date: 2005-03-04 07:34:02
Message-ID: 20050304073402.39231.qmail@web61010.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
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 

Responses

pgsql-interfaces by date

Next:From: David.JacquesDate: 2005-03-04 13:26:33
Subject: Function for determining column witdhs in libpq ?
Previous:From: Berényi GáborDate: 2005-03-04 00:00:29
Subject: Re: [INTERFACES] bcc32.mak for libpq broken? (distro 8.0.0) (fwd)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group