Alter table with arrays - Mailing list pgsql-novice

From igor
Subject Alter table with arrays
Date
Msg-id 15913127324.20000724175410@mailru.com
Whole thread Raw
Responses Re: Alter table with arrays  (Tom Lane <tgl@sss.pgh.pa.us>)
RULES on PostgreSQL  (Jesus Aneiros <aneiros@jagua.cfg.sld.cu>)
List pgsql-novice
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



pgsql-novice by date:

Previous
From: John Burski
Date:
Subject: Re: pg_dump problem
Next
From: Martin Christensen
Date:
Subject: Searching BLOBs