Dennis Brakhane <brakhane(at)googlemail(dot)com> writes:
> On Mon, May 4, 2009 at 12:53 PM, Jasen Betts <jasen(at)xnet(dot)co(dot)nz> wrote:
>> select exp(sum(ln( thiscolumn ))) from foo;
> Keep in mind that it won't work when the table containts negative
> numbers, though (or zeros, but since in this case the product is also
> zero, it doesn't matter)
Its numerical stability probably leaves something to be desired, too...
but it is a cute solution.
regards, tom lane