recurse in a single query
| От | Jean-Yves F. Barbier |
|---|---|
| Тема | recurse in a single query |
| Дата | |
| Msg-id | 20101006212544.4dc3ad4d@anubis.defcon1 обсуждение исходный текст |
| Ответы |
Re: recurse in a single query
|
| Список | 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.
В списке pgsql-novice по дате отправления: