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
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 |
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? |
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? |