How to insert columns into an array

Dirk Lutzebaeck <lutzeb@cs.tu-berlin.de>

From: Dirk Lutzebaeck <lutzeb@cs.tu-berlin.de>
To: pgsql-sql@postgreSQL.org
Date: 1998-05-28T15:15:53Z
Lists: pgsql-sql
Hi,

say you have the following two tables

CREATE TABLE t1 (
	a TEXT,
	b TEXT,
	c TEXT);

CREATE TABLE t2 (
	x TEXT[];
);

how can I insert a into x[0], b into x[1] and c into x[2]??? and how
about the other way round?

something like 

insert into t2(x[0], x[1], x[2]) select * from t1;

fails.


Thanks for help,

Dirk