Dennis Brakhane <brakh...@googlemail.com> writes:
> On Mon, May 4, 2009 at 12:53 PM, Jasen Betts <ja...@xnet.co.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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
