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  (Joe Conway <mail@joeconway.com>)
Re: an aggregate array function  (Dani Oderbolz <oderbolz@ecologic.de>)
List pgsql-hackers
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Dear hackers,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Do you think there would be any use for an aggregate which returns an array of the aggregated
(usuallysimple) type?<span style="mso-spacerun:yes">  </span>Has this already been done by anyone?<span
style="mso-spacerun:yes"> </span>I looked at the source and noticed that for each inserted item, the array utility
functionsperform a deep copy of the entire array (plus a reallocation). <span
style="mso-spacerun:yes"> </span>Normally,this is no big deal, but if executed in the query stage, it could be kind of
slow.<spanstyle="mso-spacerun:yes">  </span>I also noticed that null values inside is an item on the <span
class="SpellE">todo</span>list.<span style="mso-spacerun:yes">  </span>Is anybody currently working on
this?</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Merlin</span></font></div>

pgsql-hackers by date:

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