Thread: Fw: Arrays

Fw: Arrays

From
Bob Pawley
Date:
----- Original Message -----
From: "Bob Pawley" <rjpawley@shaw.ca>
To: "Karsten Hilbert" <Karsten.Hilbert@gmx.net>
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@gmx.net>
> To: <pgsql-general@postgresql.org>
> 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
>