On Fri, Mar 25, 2005 at 02:39:11PM -0500, Tom Lane wrote:
> "Lucas F." <lucasf(at)vagabond-software(dot)com> writes:
> > CREATE AGGREGATE "property"."pos_avg" ( BASETYPE = "int2",
> > SFUNC = "property"."ag_pos_avg_accum", STYPE = "_int4",
> > FINALFUNC = "property"."ag_pos_avg_final", INITCOND = "'{0,0}'");
>
> Too many quotes ... try INITCOND = '{0,0}'
Also, check the array subscripts in your functions. By default,
PostgreSQL array subscripts start at 1, not 0.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/