Peter Nixonn wrote:
> Hi Guys
>
>
> Has anyone written a postgres function to calculate percentages without
> giving "ERROR: division by zero" when fed zeros?
Almost certainly. The question is, what do *you* want it to do?
You'll want to customise something like:
CREATE FUNCTION percent_plus(int4, int4) RETURNS int4 AS $$
SELECT CASE WHEN $2=0 THEN -1 ELSE ($1*100)/$2 END;
$$ LANGUAGE SQL;
--
Richard Huxton
Archonet Ltd
