| From: | KeesKling <ckling(at)PLANET(dot)NL> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Storing float array |
| Date: | 2007-11-01 12:33:35 |
| Message-ID: | 13527815.post@talk.nabble.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
HI.
I want to store an array of floats size about 50,000. My first Idea was to
store them in a column 'float[]', but using JDBC and java it takes minutes
to convert the data and store it.
My next try was to use a column BYTEA and store the data as 'byte[]' and
that worked. Inspecting the data. Looking at clientside the data is OK, but
if I do that on the serverside wit PLPERL I found out that there is a big
increase in datasize and I found a lot of escape (\0)characters.
Is it possible to avoid these characters and store the bitearray as it is or
do I have to use another columntype or storing method.
Regards Kees Kling
--
View this message in context: http://www.nabble.com/Storing-float-array-tf4731022.html#a13527815
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2007-11-01 13:18:23 | Re: If Postgresql DLL files causing any kind of conflict for two different versions of Postgresql installed on one machine |
| Previous Message | dhiraj bhosale | 2007-11-01 11:15:37 | If Postgresql DLL files causing any kind of conflict for two different versions of Postgresql installed on one machine |