Re: query syntax to combine 2 set returning functions ?

Поиск
Список
Период
Сортировка
От Marc Mamin
Тема Re: query syntax to combine 2 set returning functions ?
Дата
Msg-id B6F6FD62F2624C4C9916AC0175D56D8801D949@jenmbs01.ad.intershop.net
обсуждение исходный текст
Ответ на query syntax to combine 2 set returning functions ?  (Marc Mamin <M.Mamin@intershop.de>)
Ответы Re: query syntax to combine 2 set returning functions ?
Список pgsql-general
>  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

I got it:

select  (get_table_depends('cicpg_logs', t)).* FROM get_modeltablelist('efeeds') t
        ^                                  ^

Marc


From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Marc Mamin
Sent: Freitag, 1. März 2013 13:51
To: pgsql-general@postgresql.org
Subject: [GENERAL] query syntax to combine 2 set returning functions ?

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
 


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Floating point error
Следующее
От: Vincent Veyron
Дата:
Сообщение: Re: Scalable cluster