In JDBC2 you do have the notion of arrays, but I've yet to get to them.
The only real way is to convert the Double[] to a string using
PostgreSQL's array syntax (which I can't remember what it looks like at
the moment), then store it using PreparedStatement.setString()
Peter
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: Steffen Zimmert [mailto:szimmert@crcg.edu]
Sent: Wednesday, June 23, 1999 12:05 AM
To: PostgreSQL General Mailing List; pgsql-interfaces@postgreSQL.org
Subject: [INTERFACES] Arrays in PostgreSQL
Hi,
since I have serious problems with some of the features of the JDBC
driver I am searching for a different way to store the following
structure efficiently in the PostgreSQL database.
How can I store an array of double numbers and retrieve it without
creating a row for each entry? I read something about arrays in
PostgreSQL and I wonder if this feature can be used to retrieve the
whole array at once instead of retrieving the entries sequentially?
--
Best Regards,
Steffen Zimmert
Steffen Zimmert
Fraunhofer Center for Research in Computer Graphics
Providence, Rhode Island, USA
email: szimmert@crcg.edu