2007/8/15, Merlin Moncure <[EMAIL PROTECTED]>: > On 8/14/07, Bruce Momjian <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
