query syntax to combine 2 set returning functions ?

[Marc Mamin <M.Mamin@xxxxxxxxxxxx>]

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