Andrew Bartley writes:
> function int_array_aggregate(integer[]) does not exist
int_array_aggregate() takes integers, not arrays of integers.
Depending on exactly what semantics you'd like to have, you could
probably build a custom aggregate to do this without any new C code
--- try basing it on
On Thu, Jun 20, 2013 at 12:22 AM, Andrew Bartley wrote:
> Sorry that should be aggregate int_array_aggregate not function
>
>
> On 20 June 2013 08:16, Andrew Bartley wrote:
>>
>> Hi All,
>>
>> I am trying to use the intagg extension. in 9.1.9
>>
>> I have created the extension as such "CREATE EXT
Sorry that should be aggregate int_array_aggregate not function
On 20 June 2013 08:16, Andrew Bartley wrote:
> Hi All,
>
> I am trying to use the intagg extension. in 9.1.9
>
> I have created the extension as such "CREATE EXTENSION intagg"
>
> Then tried to use the function int_array_aggregate.
Hi All,
I am trying to use the intagg extension. in 9.1.9
I have created the extension as such "CREATE EXTENSION intagg"
Then tried to use the function int_array_aggregate.
Returns this message
function int_array_aggregate(integer[]) does not exist
select int_array_aggregate(transactions) fro
Sam Mason <[EMAIL PROTECTED]> writes:
> I'm seeing big memory leaks when doing a query like:
> SELECT d.source_loc_id, d.movement_date - '2006-1-1',
> array_to_string(int_array_aggregate(l.source_ls_id),' ') AS livestockids
> FROM movedates d, livestock_locations l
> WHERE l.source_loc_i
Hi,
I've been using the intagg code to perform aggregations under the
assumption that it's going to be more efficient than the array_accum
documented elsewhere[1].
I'm seeing big memory leaks when doing a query like:
SELECT d.source_loc_id, d.movement_date - '2006-1-1',
array_to_string(int
