Re[2]: How to Alter tables with ARRAY? Help PLease - Mailing list pgsql-general

Hello,

Thank you for replay , but i still having problems with aray..

Well, i have a field OSTV which has dimention [1:9][1:6]
(i can see it in "SELECT array_dims(ostv) FROM mytable")

when i'm trying:
 "update mytable set ostv [10][3]=333.00"
i got:
 "Error while executing the query (non-fatal);
ERROR:  Invalid array subscripts"

if i make empty field wiht the neccessary dimension [10][6]
i couldn't move data from old field , because after

 "update mytable set ostvNewDim = ostvOldDim"

sets new dimension  to old value


Tell me please, what to do?


TL> Just assign a new array value to the column.  PG doesn't actually
TL> consider the dimensionality of an array to be part of the type
TL> specification; any size array will be accepted.