Received: from mail.unlisys.net (root@mail.unlisys.net [195.21.255.252]) by hub.org (8.8.8/8.7.5) with SMTP id LAA23034 for ; Thu, 28 May 1998 11:15:49 -0400 (EDT) Received: by mail.unlisys.net (Smail3.2.0.96inx) from gate.wadk-berlin.de (195.21.185.177) with esmtp id ; Thu, 28 May 1998 17:15:46 +0200 (MET DST) Received: (from lutzeb@localhost) by gate.wadk-berlin.de (8.8.7/8.8.5) id RAA13741; Thu, 28 May 1998 17:15:54 +0200 X-Authentication-Warning: gate.wadk-berlin.de: lutzeb set sender to lutzeb@ using -f From: Dirk Lutzebaeck MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Date: Thu, 28 May 1998 17:15:53 +0200 (MEST) To: pgsql-sql@postgreSQL.org Subject: How to insert columns into an array X-Mailer: VM 6.43 under 20.4 "Emerald" XEmacs Lucid Message-ID: <13677.32264.100233.239282@gate.wadk-berlin.de> X-Face: K?6k:xO"sj7_T|{X)A`r]6[I.H"<4/_nRj{n'n<4X,iC%Dd*8y1; IH'LSWu!.,a(gAToSQd HFA,|S@:/?%xa"e!VnTGLwv; s}E[%p$eh)p./sOdd=kuGo0FV-_E+nvaxIWW&@w:9wo[rm5A$OaJ:OI@~$#9q7Z+F@oaKKZl3<"<]wP/'xDm{\Q_, qPy< /dr8[rj"|&k`>07{eQ.#*\MfLT/eMhk!G$lZMN#_@_AbvIq9r!ds 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