Re: Arrays

Поиск
Список
Период
Сортировка
От Eric E
Тема Re: Arrays
Дата
Msg-id 43D92214.2020007@gmail.com
обсуждение исходный текст
Ответ на Re: Arrays  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Bob Pawley
Дата:
Сообщение: Re: Arrays
Следующее
От: Bob Pawley
Дата:
Сообщение: Fw: Arrays