From: | "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | recurse in a single query |
Date: | 2010-10-06 19:25:44 |
Message-ID: | 20101006212544.4dc3ad4d@anubis.defcon1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2010-10-06 19:31:22 | Re: Alternative to AS? |
Previous Message | Thomas Kellerer | 2010-10-06 19:07:04 | Re: Alternative to AS? |