pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Arrays in PostgreSQL 2+ messages / 2 participants [nested] [flat]
* Arrays in PostgreSQL @ 1999-06-22 23:05 Steffen Zimmert <szimmert@crcg.edu> 0 siblings, 0 replies; 2+ messages in thread From: Steffen Zimmert @ 1999-06-22 23:05 UTC (permalink / raw) To: PostgreSQL General Mailing List <pgsql-general@hub.org>; pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: [INTERFACES] Arrays in PostgreSQL @ 1999-06-23 07:03 Peter Mount <petermount@it.maidstone.gov.uk> 0 siblings, 0 replies; 2+ messages in thread From: Peter Mount @ 1999-06-23 07:03 UTC (permalink / raw) To: 'Steffen Zimmert' <szimmert@crcg.edu>; PostgreSQL General Mailing List <pgsql-general@hub.org>; pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-06-23 07:03 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1999-06-22 23:05 Arrays in PostgreSQL Steffen Zimmert <szimmert@crcg.edu> 1999-06-23 07:03 RE: [INTERFACES] Arrays in PostgreSQL Peter Mount <petermount@it.maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox