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

From Pavel Stehule
Subject Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]
Date
Msg-id 162867790708142150m6353f598md7aa0f9988554bee@mail.gmail.com
Whole thread Raw
In response to Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]  (Bruce Momjian <bruce@momjian.us>)
List 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 by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]
Next
From: "Marc G. Fournier"
Date:
Subject: Re: CVS corruption/mistagging?