Re: Patch: propose to include 3 new functions into intarray and intagg

From: Markus Wanner <markus(at)bluegap(dot)ch>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: Dmitry Koterov <dmitry(at)koterov(dot)ru>, Postgres <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Patch: propose to include 3 new functions into intarray and intagg
Date: 2008-09-05 12:40:26
Message-ID: 48C128BA.5050503@bluegap.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Gregory Stark wrote:
> I definitely like the int_array_append_aggregate function but I don't see
> anything int[] specific about it. We should be able to have a generic
> array_union() aggregate which uses the same IsA(fcinfo->context, AggState)
> trick to scribble on its state variable. It don't even see any reason it
> couldn't work for arrays of varlenas, though it would take a bit of
> restructuring.

I've just noticed that this already is a todo item:

"Add array_accum() and array_to_set() functions for arrays

The standards specify array_agg() and UNNEST."

See also:
http://archives.postgresql.org/pgsql-hackers/2007-08/msg00464.php

Regards

Markus Wanner

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2008-09-05 12:57:58 Re: Verbosity of Function Return Type Checks
Previous Message Marko Kreen 2008-09-05 12:39:52 Withdraw PL/Proxy from commitfest