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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]
Дата
Msg-id 200709140344.l8E3iBb16482@momjian.us
обсуждение исходный текст
Ответ на Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Список pgsql-hackers
This has been saved for the 8.4 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold

---------------------------------------------------------------------------

Pavel Stehule wrote:
> 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

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


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

Предыдущее
От: "Sergey E. Koposov"
Дата:
Сообщение: Re: What is happening on buildfarm member dugong
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What is happening on buildfarm member dugong