On Thu, Jun 20, 2013 at 12:22 AM, Andrew Bartley ambart...@gmail.com wrote:
Sorry that should be aggregate int_array_aggregate not function
On 20 June 2013 08:16, Andrew Bartley ambart...@gmail.com wrote:
Hi All,
I am trying to use the intagg extension. in 9.1.9
I have created the
Andrew Bartley ambart...@gmail.com 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
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) from
Sorry that should be aggregate int_array_aggregate not function
On 20 June 2013 08:16, Andrew Bartley ambart...@gmail.com 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
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',
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_id =