Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: float result rounded

    hi guys

    i have an operation like (var1-var2)*0.0025
    where var1 and var2 are float variables and
    the code gives me an rounded result like in the
    next example

    if the result would be 245.5 it returns 246
    but sometimes it gives a good result why ?

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    Are you discussing a PL/pgSQL function, or are you using SQL in a query?
    Last edited by loquin; 04-10-06 at 13:52.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts