Dennis Brakhane <brakhane@xxxxxxxxxxxxxx> writes: > On Mon, May 4, 2009 at 12:53 PM, Jasen Betts <jasen@xxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
