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