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 |/
