query syntax to combine 2 set returning functions ?

From: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: query syntax to combine 2 set returning functions ?
Date: 2013-03-01 12:51:02
Message-ID: B6F6FD62F2624C4C9916AC0175D56D8801D57B@jenmbs01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have 2 set returning functions:

select get_modeltablelist('foo') t

t
--
_emc_cubelist
_efm_modellist
_efm_sequences

select get_table_depends('cicpg_logs', '_efm_sequences') d

Typ Table Object
--- ----- -------
TR _efm_sequences _efm_sequences_tr

Now I want to combine both.

This is valid, but I can't find the syntax to get the results in multiple columns instaed of a singel 'record' column:

select get_table_depends('cicpg_logs', t) FROM get_modeltablelist('efeeds') t

get_table_depends
-----------------
(TR,_efm_sequences,_efm_sequences_tr)
(TR,_emr_reportlist,_emr_reportlist_tr)
(TR,_efm_models,_efm_models_del_tr)

regards,

Marc Mamin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2013-03-01 14:37:19 Re: Poor performance when using a window function in a view
Previous Message Albe Laurenz 2013-03-01 12:01:25 Re: [GENERAL] Floating point error