Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 99124633377;
	Sun, 19 Apr 2009 20:25:48 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 83468-01; Sun, 19 Apr 2009 20:25:47 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id D18CD633175;
	Sun, 19 Apr 2009 20:25:46 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n3JNPX6j012293;
	Sun, 19 Apr 2009 19:25:33 -0400 (EDT)
To: Robson Fidalgo <rdnf@cin.ufpe.br>
cc: pgsql-docs@postgresql.org, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgresql 8.3X supports Arrays of Composite Types? 
In-reply-to: <41534c40904191403m2eeabc27tc4bc6ce206c87464@mail.gmail.com> 
References: <41534c40904191403m2eeabc27tc4bc6ce206c87464@mail.gmail.com>
Comments: In-reply-to Robson Fidalgo <rdnf@cin.ufpe.br>
	message dated "Sun, 19 Apr 2009 18:03:26 -0300"
Date: Sun, 19 Apr 2009 19:25:32 -0400
Message-ID: <12292.1240183532@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200904/39
X-Sequence-Number: 5127

Robson Fidalgo <rdnf@cin.ufpe.br> writes:
> I am using postgresql 8.3X and I created a table (see example below) that
> has an attribute that is an Array of a Composite Type (ROW). However, I do
> not know how can I insert a record in this table.

You need some explicit casts so that the array[] construct is seen to
have the right type, eg

insert into person values ('Joe', array[row('1','1111')::phone, row('2','2222')::phone]);

			regards, tom lane