Re: Arrays

From: Eric E <whalesuit(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Arrays
Date: 2006-01-26 19:41:44
Message-ID: 43D925F8.1020704@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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:
>
>> 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
>

In response to

  • Re: Arrays at 2006-01-26 19:00:26 from Karsten Hilbert

Responses

  • Re: Arrays at 2006-01-26 23:06:34 from Michael Glaesemann

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2006-01-26 19:43:36 Re: Arrays
Previous Message Matthew T. O'Connor 2006-01-26 19:35:42 Re: VACUUM Question