Calculating product from rows - (aggregate product )

From: Allan Kamau <allank(at)sanbi(dot)ac(dot)za>
To: Postgres-General <pgsql-general(at)postgresql(dot)org>
Subject: Calculating product from rows - (aggregate product )
Date: 2009-05-04 08:02:22
Message-ID: 49FEA10E.5090401@sanbi.ac.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I would like to calculate a product of a field's values of a relation,
this function may multiply each value and give the result as a single
float number.

For example:

CREATE table imaginary(id INTEGER NOT NULL, some_field FLOAT
NULL,primary key(id));

INSERT INTO imarginary(1,0.333);INSERT INTO imarginary(2,0.667);INSERT
INTO imarginary(3,0.4);

SELECT prod(some_field) FROM imarginary;

would give 0.0888444 (which is 0.333*0.667*0.4)

Is there an already existing function that does this.

Allan.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vladimir N. Indik 2009-05-04 08:14:57 Re: could not bind IPv4 socket
Previous Message Bill Moseley 2009-05-04 05:02:40 Re: Tracking down a deadlock