What do you think about the other question about an 'array creating aggregate', is that a useful contribution?
Hmm, either I'm not understanding you, or you're not understanding me ;-)
First, see contrib/intagg. Second, the following works in 7.4devel:
-- create test data for polymorphic aggregates create table t(f1 int, f2 float, f3 float); insert into t values(1,11.1,21.1); insert into t values(1,11.2,21.2); insert into t values(1,11.3,21.3); insert into t values(2,12.1,22.1); insert into t values(2,12.2,22.2); insert into t values(2,12.3,22.3); insert into t values(3,13.1,23.1); insert into t values(3,13.2,23.2);
CREATE AGGREGATE myagg1
(
BASETYPE = float8,
SFUNC = array_append,
STYPE = float8[],
INITCOND = '{}'
);CREATE AGGREGATE myagg2
(
BASETYPE = float8[],
SFUNC = array_cat,
STYPE = float8[],
INITCOND = '{}'
);regression=# select f1, myagg1(f2) from t group by f1;
f1 | myagg1
----+------------------
3 | {13.1,13.2}
2 | {12.1,12.2,12.3}
1 | {11.1,11.2,11.3}
(3 rows)regression=# select f1, myagg2(array[f2,f3]) from t group by f1;
f1 | myagg2
----+---------------------------------------
3 | {{13.1,23.1},{13.2,23.2}}
2 | {{12.1,22.1},{12.2,22.2},{12.3,22.3}}
1 | {{11.1,21.1},{11.2,21.2},{11.3,21.3}}
(3 rows)Joe
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
