[GENERAL] query syntax to combine 2 set returning functions ?

[Marc Mamin]

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