Alter table with arrays

From: igor <igor_kh(at)mailru(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Alter table with arrays
Date: 2000-07-24 13:54:10
Message-ID: 15913127324.20000724175410@mailru.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice pgsql-sql

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert D. Nelson 2000-07-24 14:06:00 RE: how connect visual basic to pgsql?
Previous Message Philip Warner 2000-07-24 13:48:03 Re: Problem with inserting newlines and ' characters

Browse pgsql-novice by date

  From Date Subject
Next Message Martin Christensen 2000-07-24 14:03:21 Searching BLOBs
Previous Message Tom Lane 2000-07-24 06:04:57 Re: Is there any way to speed up PL/TCL functions?

Browse pgsql-sql by date

  From Date Subject
Next Message Kyle 2000-07-24 16:30:25 altering column constraints
Previous Message Tom Lane 2000-07-24 06:04:57 Re: Is there any way to speed up PL/TCL functions?