recurse in a single query

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.

Responses

Browse pgsql-novice by date

  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?