Re: benefits of an Array Column?

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: benefits of an Array Column?
Дата
Msg-id 40D5E5AA.8030706@joeconway.com
обсуждение исходный текст
Ответ на Re: benefits of an Array Column?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: benefits of an Array Column?  (János <janos.lobb@yale.edu>)
Список pgsql-novice
Tom Lane wrote:
> jarednevans@yahoo.com writes:
>>I fail to see the scenarios where this would be an useful feature.  How
>>is this better than linking to another table that could serve the same
>>purpose?

> I think probably the rule of thumb is that arrays work when you have
> data items that have an array-like structure, but that substructure
> isn't interesting from the standpoint of the database structure.

I agree, but would add that arrays are often very useful as
non-persistent structures for processing data, e.g. in PL/pgSQL functions.

Joe

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: benefits of an Array Column?
Следующее
От:
Дата:
Сообщение: Re: libpq.so