arrays of rows and dblink
| От | Torsten Förtsch |
|---|---|
| Тема | arrays of rows and dblink |
| Дата | |
| Msg-id | 53613841.9060703@gmx.net обсуждение исходный текст |
| Ответы |
Re: arrays of rows and dblink
Re: arrays of rows and dblink |
| Список | pgsql-general |
Hi,
we have the ROW type and we have arrays. We also can create arrays of
rows like:
select array_agg(r)
from (values (1::int, 'today'::timestamp, 'a'::text),
(2, 'yesterday', 'b')) r(a,b,c);
array_agg
-------------------------------------------------------------------
{"(1,\"2014-04-30 00:00:00\",a)","(2,\"2014-04-29 00:00:00\",b)"}
Now I want to execute that query via dblink on a remote server. How do I
specify the result type?
select tb.* from dblink( 'dbname=postgres', $$
select array_agg(r)
from (values (1::int, 'today'::timestamp, 'a'::text),
$$) tb( WHAT DO I PUT HERE? )
Thanks,
Torsten
В списке pgsql-general по дате отправления: