| 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: | Whole Thread | Raw Message | 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? |