Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]
Дата
Msg-id 162867790708142150m6353f598md7aa0f9988554bee@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]  ("Merlin Moncure" <mmoncure@gmail.com>)
Ответы Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]
Список pgsql-hackers
2007/8/15, Merlin Moncure <mmoncure@gmail.com>:
> On 8/14/07, Bruce Momjian <bruce@momjian.us> wrote:
> >
> > TODO item?
>
> I would say yes...array_accum is virtually an essential function when
> working with arrays and the suggested array_to_set (and it's built in
> cousin, _pg_expand_array) really should not be built around
> generate_series when a C function is faster and will scale much
> better.
>

Hello Merlin

array_accum is good sample of PostgreSQL possibilities. But it is slow.

SELECT ARRAY(SELECT ... FROM ...)) is much faster. :(

so I unlike not necessary aggregate functions

I agree. These constructs can be showed in doc

Regards
Pavel Stehule


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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: CVS corruption/mistagging?