I want to fill an array in my database with the content of a file. I
know the number of value I have to add (written in the begining of the
file), but I'd like not to load all the file in memory. So I can't put the
value within the INSERT command. Is it possible to insert an array with a
fixed size and to fill at after?
I have tried things like :
CREATE TABLE timeseries (seriesid int4 PRIMARY KEY, samples float8 []) ;
INSERT INTO timeseries (seriesid, samples[1000]) VALUES (1, '{}') ;
UPDATE timeseries SET samples[1]=5 WHERE seriesid=1 ; -> ERROR : array_set: array bound exceeded
Any help?
Guillaume.