Continuing to try to use format_type to output all types, I get the
following in the regression database:
CREATE AGGREGATE newavg ( BASETYPE = integer, SFUNC = int4_accum, STYPE = "numeric[]", INITCOND = '{0,0,0}',
FINALFUNC= numeric_avg
);
where the original source was:
CREATE AGGREGATE newavg ( sfunc = int4_accum, basetype = int4, stype = _numeric, finalfunc = numeric_avg,
initcond1= '{0,0,0}'
);
The problem is the "numeric[]" type. Does this mean I should go back to
just using typnam for aggregates? For all but table definitions? Or is
there an alternate solution.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \| | --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/