Re: arrays of rows and dblink

From: Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net>
To: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: arrays of rows and dblink
Date: 2014-04-30 18:59:00
Message-ID: 536147F4.3000805@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks,
Torsten

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2014-04-30 19:02:38 Re: arrays of rows and dblink
Previous Message David G Johnston 2014-04-30 18:19:00 Re: arrays of rows and dblink