From: Tom Lane <tgl@sss.pgh.pa.us>
To: b t <qtboyzz@yahoo.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: how to parse an proargtypes array?
Date: Fri, 04 Mar 2005 10:16:46 -0500
Message-ID: <27425.1109949406@sss.pgh.pa.us> (raw)
In-Reply-To: <20050304073402.39231.qmail@web61010.mail.yahoo.com>
References: <20050304073402.39231.qmail@web61010.mail.yahoo.com>
b t <qtboyzz@yahoo.com> writes:
> 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.
Perhaps the regprocedure output converter will help you. Forget
proargtypes, just cast the function's OID to regprocedure.
If you really want to deal with the individual function argument type
OIDs, regtype would help with converting those to useful text; or see
format_type().
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, qtboyzz@yahoo.com
Subject: Re: how to parse an proargtypes array?
In-Reply-To: <27425.1109949406@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox