Message-ID: <4236980E.3080807@archonet.com>
Date: Tue, 15 Mar 2005 08:08:46 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 1.0 (X11/20041206)
MIME-Version: 1.0
To: Robert.Farrugia@go.com.mt
Cc: pgsql-sql@postgresql.org
Subject: Re: Inserting values in arrays
References: 
 <OF96764BBA.060DB4E6-ONC1256FC4.0061C3D4-C1256FC4.00623B75@go.com.mt>
In-Reply-To: 
 <OF96764BBA.060DB4E6-ONC1256FC4.0061C3D4-C1256FC4.00623B75@go.com.mt>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Robert.Farrugia@go.com.mt wrote:
> CREATE TABLE test ( details varchar[]);
> CREATE TABLE test2 ( textvalue1 varchar, textvalue2 varchar);
> INSERT INTO test2 VALUES ('Hello1', 'World1');
> INSERT INTO test2 VALUES ('hello2', 'World2');

> and I am expecting the following rows in test
> {'Hello1', 'World1'}
> {'Hello2', 'World2'}

> Postgres version I am using is 7.3.4

Well, from 7.4 you can do:

INSERT INTO test SELECT ARRAY[textvalue1, textvalue2] FROM test2;
INSERT 0 2
richardh=> SELECT * FROM test;
      details
-----------------
  {Hello1,World1}
  {hello2,World2}
(2 rows)

I think in 7.3 you might have to write your own function to assemble the 
array. I'm not an array expert though, so might be worth checking the 
mailing list archives.

--
   Richard Huxton
   Archonet Ltd