Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novicepgsql-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

pgsql-novice by date

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

pgsql-general by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group