Re: recurse in a single query

Jean-Yves F. Barbier, 06.10.2010 21:25:
> Hi list,
>
> I'd like to know how to recurse on some elements into a single query
>
> SELECT P.oid, P.proname, P.proowner, P.pronargs, P.proargtypes::int[],
> T.typname AS "PROCRETURN"  FROM pg_proc P INNER JOIN pg_type T ON
> P.prorettype = T.oid WHERE pronamespace = 230741;
>
>    oid   | proname | proowner | pronargs |    proargtypes    | PROCRETURN
> --------+---------+----------+----------+-------------------+------------
>   230749 | whoami  |   230738 |        0 | {}                | oid
>   237125 | jyadd   |   230738 |        2 | [0:1]={1700,1700} | numeric
>
> The goal is to get {numeric,numeric} instead of {1700,1700} still with one
> query (if possible?)
>

SELECT pg_get_function_arguments(p.oid)
FROM pg_proc p

Thomas