Re: syntax issue with custom aggregator

"Lucas F." <lucasf@vagabond-software.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}'

            regards, tom lane