RE: [INTERFACES] Arrays in PostgreSQL

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(at)crcg(dot)edu]
Sent: Wednesday, June 23, 1999 12:05 AM
To: PostgreSQL General Mailing List; pgsql-interfaces(at)postgreSQL(dot)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(at)crcg(dot)edu