Re: Arrays - Mailing list pgsql-general

From Eric E
Subject Re: Arrays
Date
Msg-id 43D92214.2020007@gmail.com
Whole thread Raw
In response to Re: Arrays  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
I second that, and I'd love to have someone clarify the appropriate
time to use arrays vs. more columns or an referenced tabled.  I've
always found that confusing.

Thanks,

Eric

Karsten Hilbert wrote:

  And why would that be undesirable ?

On Thu, Jan 26, 2006 at 10:15:22AM -0800, Bob Pawley wrote:


<blockquote cite="mid20060126190024.GA5414@merkur.hilbert.loc"
 type="cite">

    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

pgsql-general by date:

Previous
From: Bob Pawley
Date:
Subject: Re: Arrays
Next
From: Bob Pawley
Date:
Subject: Fw: Arrays