Thread

How to insert columns into an array

Dirk Lutzebaeck <lutzeb@cs.tu-berlin.de> — 1998-05-28T15:15:53Z

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