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

Re: How to describe functions.

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to describe functions.
Date: 2009-12-10 22:03:12
Message-ID: hfrr6v$7e6$1@ger.gmane.org (view raw or flat)
Thread:
Lists: pgsql-novice
Mladen Gogala wrote on 10.12.2009 22:39:
> I  would like to write a single query listing all of the function argument
> types. I know that I can write a procedure but I would prefer a single
> query. The problem is that in pg_proc, the column proargtypes is of the
> type "oidvector", which is another name for an array oid[]. The types
> are, of course in pg_type table. The problem here is the array handling.
> what I would really like is something like this:
>
> select p.proname,(for($i=0;$i<p.pronargs;$i++ { t.typename where
> t.oid=p.proargtypes[$i] }
> from pg_proc p, pg_type t;
>

If you are on 8.4 you can use:

select proname, pg_catalog.pg_get_function_arguments(oid)
from pg_proc
;

Thomas



In response to

pgsql-novice by date

Next:From: A. KretschmerDate: 2009-12-11 06:10:09
Subject: Re: one or 2 transactions?
Previous:From: Mladen GogalaDate: 2009-12-10 21:39:34
Subject: How to describe functions.

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