Received: from cx379956-a.nwptn1.va.home.com (root@208-58-212-90.s344.tnt1.lnhdc.md.dialup.rcn.com [208.58.212.90]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA89880 for ; Thu, 13 Apr 2000 13:39:52 -0400 (EDT) (envelope-from vassili@erols.com) Received: from torch (vasia@localhost [127.0.0.1]) by cx379956-a.nwptn1.va.home.com (8.9.1a/8.8.7) with SMTP id NAA03451 for ; Thu, 13 Apr 2000 13:37:56 -0400 Message-ID: <38F605EE.5FC3A75C@erols.com> Date: Thu, 13 Apr 2000 13:37:50 -0400 From: Vassili A Akimov Organization: Touch Technology X-Mailer: Mozilla 3.01Gold (X11; I; Linux 2.2.14 i586) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Array question Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/148 Hi all! I, probably, have really simple question, but I can't go further. I have two tables: one is empty like +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ | home phone number | int4[] | var | and another one full like +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ | first | int4 | 4| | second | int4 | 4| | third | int4 | 4| I need to put all elements from second table into a first one. So each string in second table becomes a string in a first one, so firts colun becomes a first array element in first table second is second and so on. I tried several queries in order to do this, but failed. Can anyone help? Thank you.