On Wed, Mar 23, 2011 at 8:03 AM, Disc Magnet <discmagnet@xxxxxxxxx> wrote: > I was learning how to create my own aggregate functions from > http://www.postgresql.org/docs/9.0/static/xaggr.html > > I copied the avg() example as > > CREATE TABLE numbers ( > value integer > ); > > insert into numbers values (2); > insert into numbers values (3); > insert into numbers values (4); > > CREATE AGGREGATE myavg(float8) ( > sfunc = float8_accum, > stype = float8[], > finalfunc = float8_avg, > initcond = '{0,0}' > ); > > On trying to run this, I get this error: > > cdb=# select myavg(value) from numbers; > ERROR: float8_accum: expected 3-element float8 array > > How can I fix this? how embarrassing -- the initcont should be: '{0,0,0}' :^). merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
