PostgreSQL documentation specifies 2-element array for float8_accum but 3-element array expected

From: Disc Magnet <discmagnet(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL documentation specifies 2-element array for float8_accum but 3-element array expected
Date: 2011-03-23 13:03:42
Message-ID: AANLkTimQJ5ukzyOiqCAWdkkiApto9XKZghLYYfdGw0L3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2011-03-23 13:57:35 Re: pg_dump problems
Previous Message Vick Khera 2011-03-23 12:40:42 Re: pg_dump problems