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

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(at)gmail(dot)com>:
> > On 8/14/07, Bruce Momjian <bruce(at)momjian(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +