Re: arrays of rows and dblink

Torsten Förtsch wrote
> On 30/04/14 20:19, David G Johnston wrote:
>> ISTM that you have to "CREATE TYPE ..." as appropriate then
>>
>> ... tb ( col_alias type_created_above[] )
>>
>> There is only so much you can do with anonymous types (which is what the
>> ROW
>> construct creates; ROW is not a type but an expression anchor - like
>> ARRAY[...]) that tells the parser how to interpret what follows.
>
> I thought so. Do I have to create the type in both databases or only on
> the receiving site?

No idea but it would probably be a good idea to create the type on both
sides regardless of what is required.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/arrays-of-rows-and-dblink-tp5802035p5802054.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.