Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions] - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]
Date
Msg-id 200709140344.l8E3iBb16482@momjian.us
Whole thread Raw
In response to Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List 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 by date:

Previous
From: "Sergey E. Koposov"
Date:
Subject: Re: What is happening on buildfarm member dugong
Next
From: Tom Lane
Date:
Subject: Re: What is happening on buildfarm member dugong