Received: from pain.crcg.edu (pain.crcg.edu [207.252.32.124]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA15348 for ; Tue, 22 Jun 1999 16:09:28 -0400 (EDT) (envelope-from szimmert@crcg.edu) Received: from crcg.edu (wheel.crcg.edu [207.252.32.136]) by pain.crcg.edu (8.9.1b+Sun/8.9.1) with ESMTP id QAA20182; Tue, 22 Jun 1999 16:06:36 -0400 (EDT) Message-ID: <377016A2.7F0A45E3@crcg.edu> Date: Tue, 22 Jun 1999 16:05:06 -0700 From: Steffen Zimmert Organization: Fraunhofer CRCG, Inc. X-Mailer: Mozilla 4.61 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: PostgreSQL General Mailing List , pgsql-interfaces@postgreSQL.org Subject: Arrays in PostgreSQL Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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