On Wed, Aug 7, 2013 at 3:53 AM, Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx> 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.