From: | Guillaume Marçais <gus(at)nist(dot)gov> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | |
Date: | 1999-05-24 17:42:31 |
Message-ID: | Pine.LNX.4.05.9905241324160.30895-100000@dstp02.ncsl.nist.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson, DeJuan | 1999-05-24 18:53:17 | RE: [SQL] Problems with refint.so and 6.5 Beta |
Previous Message | MAILER-DAEMON | 1999-05-24 04:35:26 | Undeliverable Message |