recurse in a single query - Mailing list pgsql-novice

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?)

JY
--
You've got to pity New Mexico... so far from heaven and so close to Texas.