Quick Links

Calculating percentages in Postgresql

From:	Peter Nixonn <listuser(at)peternixon(dot)net>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Calculating percentages in Postgresql
Date:	2006-11-21 12:59:16
Message-ID:	ejut75$45a$1@sea.gmane.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi Guys

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

TIA

--

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc

Responses

Re: Calculating percentages in Postgresql at 2006-11-21 14:22:59 from Richard Huxton
Re: Calculating percentages in Postgresql at 2006-11-21 14:32:22 from A. Kretschmer
Re: Calculating percentages in Postgresql at 2006-11-21 14:38:52 from Jerry Sievers
Re: Calculating percentages in Postgresql at 2006-11-21 14:47:53 from Tino Wildenhain
Re: Calculating percentages in Postgresql at 2006-11-21 15:01:44 from Richard Broersma Jr

Browse pgsql-general by date

	From	Date	Subject
Next Message	Reid Thompson	2006-11-21 13:22:09	Vienna migrating some DB's from Oracle to PG
Previous Message	Thomas H.	2006-11-21 12:32:26	Re: tsearch trigger: function public.tsearch2(tsvector, text) does not exist