From: b t <qtboyzz@yahoo.com>
To: pgsql-interfaces@postgresql.org
Subject: how to parse an proargtypes array?
Date: Thu, 3 Mar 2005 23:34:02 -0800 (PST)
Message-ID: <20050304073402.39231.qmail@web61010.mail.yahoo.com> (raw)
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
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: qtboyzz@yahoo.com
Subject: Re: how to parse an proargtypes array?
In-Reply-To: <20050304073402.39231.qmail@web61010.mail.yahoo.com>
* 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