Re: an aggregate array function - Mailing list pgsql-hackers

From Dani Oderbolz
Subject Re: an aggregate array function
Date
Msg-id 3F26916A.7030508@ecologic.de
Whole thread Raw
In response to an aggregate array function  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Responses Re: an aggregate array function  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Merlin Moncure wrote:

> Dear hackers,
>
>  
>
> Do you think there would be any use for an aggregate which returns an 
> array of the aggregated (usually simple) type?  Has this already been 
> done by anyone?  I looked at the source and noticed that for each 
> inserted item, the array utility functions perform a deep copy of the 
> entire array (plus a reallocation).  Normally, this is no big deal, 
> but if executed in the query stage, it could be kind of slow.  I also 
> noticed that null values inside is an item on the todo list.  Is 
> anybody currently working on this?
>
>  
>
> Merlin
>
I got another question to this:
why does PostgreSQL support Arrays in the first place?
For my taste, its a very messy concept...

Regards,
Dani



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Make clean fails
Next
From: Tom Lane
Date:
Subject: Re: Make clean fails