Re: rounding down a number

Try subtracting .01 prior to passing the number to the rounding
function.

________________________________________
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Michael
Sent: Friday, March 30, 2007 4:39 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] rounding down a number

Hi,
I'm trying to round down any number with a half, but keep the round
function for all other fractions.
For example

100.1 becomes 100
100.4 becomes 100
100.5 becomes 100 (this one would ordinarily round to 101)
100.6 becomes 101
100.9 becomes 101

Thanks, Mick

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender and delete it. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
No employee or agent is authorized to conclude any binding agreement on behalf of Visa Lighting with another party by email without express written confirmation by an authorized representative of the Company.
Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.