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.