Re: Calculating percentages in Postgresql

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Peter Nixonn <listuser(at)peternixon(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Calculating percentages in Postgresql
Date: 2006-11-21 15:01:44
Message-ID: 281183.19684.qm@web31815.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


--- Peter Nixonn <listuser(at)peternixon(dot)net> wrote:

> Hi Guys
>
>
> Has anyone written a postgres function to calculate percentages without
> giving "ERROR: division by zero" when fed zeros?

maybe you could employee the nullif() function to trap zeros for this?
http://www.postgresql.org/docs/8.2/interactive/functions-conditional.html#AEN13119

Regards,

Richard Broersma Jr.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-11-21 15:06:45 Re: [HACKERS] Client SSL validation using root.crt
Previous Message Tino Wildenhain 2006-11-21 14:47:53 Re: Calculating percentages in Postgresql