an aggregate array function - Mailing list pgsql-hackers

From Merlin Moncure
Subject an aggregate array function
Date
Msg-id 303E00EBDD07B943924382E153890E5434A9AE@cuthbert.rcsinc.local
Whole thread Raw
Responses Re: an aggregate array function
Re: an aggregate array function
List pgsql-hackers

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

pgsql-hackers by date:

Previous
From: ivan
Date:
Subject: Re: arrays
Next
From: Bruce Momjian
Date:
Subject: Re: Regression test failure date.