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:[EMAIL PROTECTED]] Sent: Wednesday, June 23, 1999 12:05 AM To: PostgreSQL General Mailing List; [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
