So the solution can be: (i) either write a function to insert the values into the array one by one (ii) or else upgrade to 7.4 (or 8) to use the ARRAY syntax.
> 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.
