Arrays in PostgreSQL

From: Steffen Zimmert <szimmert(at)crcg(dot)edu>
To: PostgreSQL General Mailing List <pgsql-general(at)hub(dot)org>, pgsql-interfaces(at)postgreSQL(dot)org
Subject: Arrays in PostgreSQL
Date: 1999-06-22 23:05:06
Message-ID: 377016A2.7F0A45E3@crcg.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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(at)crcg(dot)edu

Browse pgsql-general by date

  From Date Subject
Next Message Kenny Leong 1999-06-23 04:31:27 subcribe
Previous Message Steffen Zimmert 1999-06-22 21:51:08 Re: [INTERFACES] JDBC:Using Large Objects

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tatsuo Ishii 1999-06-23 01:31:17 Re: [INTERFACES] JDBC and character sets
Previous Message Steffen Zimmert 1999-06-22 21:51:08 Re: [INTERFACES] JDBC:Using Large Objects