Received: from mx2.mailru.com (mx2.mailru.com [193.124.133.9]) by hub.org (8.10.1/8.10.1) with ESMTP id e6ODsQh52303 for ; Mon, 24 Jul 2000 09:54:26 -0400 (EDT) Received: from 194.84.213.76 ([194.84.213.76]) (authenticated) by mx2.mailru.com (8.10.0/8.10.0) with ESMTP id e6ODlAh05995 for ; Mon, 24 Jul 2000 17:47:11 +0400 (MSD) Date: Mon, 24 Jul 2000 17:54:10 +0400 From: igor X-Mailer: The Bat! (v1.44) UNREG / CD5BF9353B3B7091 Reply-To: igor Organization: osb X-Priority: 3 (Normal) Message-ID: <15913127324.20000724175410@mailru.com> To: pgsql-novice@postgresql.org Subject: Alter table with arrays In-reply-To: <23362.964418697@sss.pgh.pa.us> References: <00072401305903.00253@comptechnews> <23362.964418697@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/123 Hi ! Help me please to alter table with arrays . The table was created : create stat (st char(20), stv float[][], str float[][]); Usualy I add new row as follow: insert into stat select '4090903' as st, '{{0,0,0,0,0,0},{0,0,0,0,0,0}}' as str, '{{0,0,0,0,0,0},{0,0,0,0,0,0}}' as stv ; And now I would like to increase the number of colomns of array from two to tree. What is the way to fulfill these operation? Thanks . Igor