On Wed, Aug 7, 2013 at 3:53 AM, Raghavendra <
raghavendra....@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.
http://www.efficito.com/learn_more.shtml

Reply via email to