Re: Populating array of composite datatype - Mailing list pgsql-general

From Raghavendra
Subject Re: Populating array of composite datatype
Date
Msg-id CA+h6AhiGDvqFmt4BfJwChyjXnuq7jf27=xagfzy2n4G_=6dyHg@mail.gmail.com
Whole thread Raw
In response to Re: Populating array of composite datatype  (Chris Travers <chris.travers@gmail.com>)
Responses Re: Populating array of composite datatype  (Sameer Thakur <samthakur74@gmail.com>)
List pgsql-general

On Wed, Aug 7, 2013 at 3:53 AM, Raghavendra <raghavendra.rao@enterprisedb.com> wrote:

postgres=# insert into foo values (array[row(1,2)::abc]);


Also because all array members must be of the same db type, you can:

insert into foo values (array[row(1,2)]::abc[]).  This can be helpful if you have more than one array member. 

Agreed. Thank you Chris.

--Raghav

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Populating array of composite datatype
Next
From: Luca Ferrari
Date:
Subject: Re: Staging Database