Postgres Pro
Downloads
Home   >   mailing lists

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

From Chris Travers
Subject Re: Populating array of composite datatype
Date
Msg-id CAKt_ZfskPwqZpCFvYQWvYHaNmztYBAs+6EP7y9Eavgwx=yu+JA@mail.gmail.com
Whole thread Raw
In response to Re: Populating array of composite datatype  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Responses Re: Populating array of composite datatype  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-general
Tree view



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. 


--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.

pgsql-general by date:

Previous
From: Raghavendra
Date:
Subject: Re: Populating array of composite datatype
Next
From: Raghavendra
Date:
Subject: Re: Populating array of composite datatype