Rafael Barrera Oro wrote:
> Hello, i have the following problem and i was wondering if you coulde help
> me. I'll try to describe it as in depth as i can.
> I have a FUNCTION in a postgresql database which subtracts two DOUBLE
> PRECISION FIELDS and returns the result. The problem is that when the result
> should be zero, the number i
> get is a number ridiculously close to zero in scientific notation (for
> example 2.4697823124E-14) but not zero.
The short answer is - never expect the subtraction of two "equal"
floating point values to be zero. Instead of testing with equality, test
with a very small range.
If you really need exact values (say, you're working with money) use the
NUMERIC type instead.
In response to
pgsql-jdbc by date
|Next:||From: Pushker Chaubey||Date: 2008-04-08 11:54:23|
|Subject: Connection breaks with in transaction with a commit|
|Previous:||From: Rafael Barrera Oro||Date: 2008-04-07 14:35:22|
|Subject: PostgreSQL FUNCTION return problem|