Re: Calculating percentages in Postgresql

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