----- Original Message -----
From: "Bob Pawley" <rjpawley@xxxxxxx>
To: "Karsten Hilbert" <Karsten.Hilbert@xxxxxxx>
Sent: Thursday, January 26, 2006 11:26 AM
Subject: Re: [GENERAL] Arrays
Because with arrays I can include other information such as pointers to
conversion factors and hopefully implement systems more easily with all
pertinent information tied to a single source (single column).
Bob
----- Original Message -----
From: "Karsten Hilbert" <Karsten.Hilbert@xxxxxxx>
To: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Thursday, January 26, 2006 11:00 AM
Subject: Re: [GENERAL] Arrays
On Thu, Jan 26, 2006 at 10:15:22AM -0800, Bob Pawley wrote:
I would like to make a table of 20 plus columns the
majority of columns being arrays.
The following test works. The array will hold up to five
characteristics of each parameter including the unit of
measurement used. Using traditional methods I would need six
columns to accomplish the same end (Min, Max, Norm plus a
unit column for each).
And why would that be undesirable ?
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
