Whit Armstrong wrote:
> I needed to write a product aggregate function, and just happened to
> find this example in the nodes to the 8.0 manual:
>
[...]
>
> but that example looks pretty different than the ones found in the 8.3
> manual (avg for instance):
>
[...]
>
> Are there any experts out there who have defined a product or
> cumulative product function that abides best practices who would be
> willing to share?
I don't know what "best practices" are, but the following works
fine on PostgreSQL 8.3 and 8.4:
CREATE AGGREGATE mul(double precision) (SFUNC=float8mul, STYPE=double precision, INITCOND=1);
Yours,
Laurenz Albe