Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 1E51A632821;
	Sun, 19 Apr 2009 18:08:23 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 37824-09; Sun, 19 Apr 2009 18:08:16 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gx0-f220.google.com (mail-gx0-f220.google.com
	[209.85.217.220])
	by mail.postgresql.org (Postfix) with ESMTP id A22106326CF;
	Sun, 19 Apr 2009 18:08:20 -0300 (ADT)
Received: by gxk20 with SMTP id 20so4295953gxk.19
	for <multiple recipients>; Sun, 19 Apr 2009 14:08:19 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:content-type;
	bh=t6sROOcZ4poJwcpT53cnLa7rpmPwGNX+u0NceWWvtvg=;
	b=QsnOCU13g3BZ1DtJAS9Laugw3ax4aCkgkbFXAA9sQ4BMVwlCBaLgIpUI64XaWcIgl9
	9P+CFNRGkV+D/DCTQnlIaaAHv4am65sUfW90Rxne6uE4lNKFiDeIz5U54MIVAQjfocgQ
	Ej/ih+6YUD+XfqcR++o63oRVuL54DN9MEnVoI=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:content-type;
	b=eKoKuc0MktEXwpSrjnvQJBHuKi3KUEAD3L1MhNJ5xBwt3PxcJN9xe7xGVGamejgPTF
	+30fmqAYNtht67FAgYB3sOV1+8cAVFWKqlGf4vVnM77+EQalwhHgHwQKdxSAgLHyODmF
	UhY7V13aXCaPA/KInedpcx+2sde3poqH6pBwE=
MIME-Version: 1.0
Received: by 10.231.18.4 with SMTP id u4mr3137398iba.33.1240175298855;
 Sun, 19
	Apr 2009 14:08:18 -0700 (PDT)
In-Reply-To: <41534c40904191403m2eeabc27tc4bc6ce206c87464@mail.gmail.com>
References: <41534c40904191403m2eeabc27tc4bc6ce206c87464@mail.gmail.com>
Date: Sun, 19 Apr 2009 18:08:18 -0300
Message-ID: <41534c40904191408t7f9b4db7lb48889ecb0abf312@mail.gmail.com>
Subject: Re: Postgresql 8.3X supports Arrays of Composite Types?
From: Robson Fidalgo <robson.fidalgo@gmail.com>
To: pgsql-docs@postgresql.org, pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary=002215046b4725c4a10467eed0f3
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200904/38
X-Sequence-Number: 5126

--002215046b4725c4a10467eed0f3
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

>
> Hello,
> 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.
>
> Well, I've searched the mailing lists and have found little said about the
> OR features. In postgres 8.3X on-line documentation (
> http://www.postgresql.org/docs/8.3/static/arrays.html) I found "Arrays of
> any built-in or user-defined base type, enum type, or composite type can be
> created", however there is no example that explains how can I do an insert
> into an attribute that is an Array of Composite Type. Considering the
> example below, "persons have N phones" I create (with success) the Person
> table with an array of phones, but I have not success with Insert values.
> There is some one that can help me?
>
> Thanks in advances,
>
> Robson
>
> Example:
>
> CREATE table phone (
>   cod varchar,
>   num varchar);
>
> CREATE TABLE person (
>   name varchar,
>   telephone phone[]);
>
> Until here is everything ok, but I have not success with insert values,
> then I tried:
>
> 1)insert into person values ('Joe', '{("1","1111"),("2","2222") }');
> 2)insert into person values ('Joe', array[('1','1111'),('2','2222')]);
> 3)insert into person values ('Joe',
> array[row('1','1111'),row('2','2222')]);
> 4)insert into person values ('Joe',
> _phone[phone('1','1111'),phone('2','2222')]);**
> ** considering _phone = name of array type (automatically created by
> postgres) and phone = name of composite type (also automatically created by
> postgres)
>

--002215046b4725c4a10467eed0f3
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div class=3D"gmail_quote">
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<p>Hello,<br>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). Ho=
wever, I do not know how can I insert a record in this table. </p>
<p>Well, I&#39;ve searched the mailing lists and have found little said abo=
ut the OR features. In postgres 8.3X on-line documentation (<a href=3D"http=
://www.postgresql.org/docs/8.3/static/arrays.html" target=3D"_blank">http:/=
/www.postgresql.org/docs/8.3/static/arrays.html</a>) I found &quot;Arrays o=
f any built-in or user-defined base type, enum type, or composite type can =
be created&quot;, however there is no example that explains how can I do an=
 insert into an attribute that is an Array of Composite Type. Considering t=
he example below, &quot;persons have N phones&quot; I create (with success)=
 the Person table with an array of phones, but I have not success with Inse=
rt values. There is some one that can help me? </p>

<p>Thanks in advances,</p>
<p>Robson</p>
<p>Example:</p>
<p>CREATE table phone (<br>=A0 cod varchar,<br>=A0 num varchar);</p>
<p>CREATE TABLE person ( <br>=A0 name varchar,<br>=A0 telephone phone[]);</=
p>
<p>Until here is everything ok, but I have not success with insert values, =
then I tried:</p>
<p>1)insert into person values (&#39;Joe&#39;, &#39;{(&quot;1&quot;,&quot;1=
111&quot;),(&quot;2&quot;,&quot;2222&quot;) }&#39;);<br>2)insert into perso=
n values (&#39;Joe&#39;, array[(&#39;1&#39;,&#39;1111&#39;),(&#39;2&#39;,&#=
39;2222&#39;)]);<br>
3)insert into person values (&#39;Joe&#39;, array[row(&#39;1&#39;,&#39;1111=
&#39;),row(&#39;2&#39;,&#39;2222&#39;)]);<br>4)insert into person values (&=
#39;Joe&#39;, _phone[phone(&#39;1&#39;,&#39;1111&#39;),phone(&#39;2&#39;,&#=
39;2222&#39;)]);**<br>
** considering _phone =3D name of array type (automatically created by post=
gres) and phone =3D name of composite type (also automatically created by p=
ostgres)<br></p></blockquote></div><br>

--002215046b4725c4a10467eed0f3--