You are right!
I am doing something wrong? I understand that there is a difference but I
don't know why.
mex2=# select
mex2-# age(endeddatetime,starteddatetime),
mex2-# time,
mex2-# date_part('second',(age(endeddatetime,starteddatetime)))*1000,
mex2-# date_part('second',(age(endeddatetime
On Tue, 22 Jun 2004, Mauricio CASTRO wrote:
> You are right!
>
> I am doing something wrong? I understand that there is a difference but I
> don't know why.
Floating point math is inexact. The date_part(...) is returning a value
that is very close to, but not exactly 4.031 due to accuracy limita
On Tue, 22 Jun 2004, PostgreSQL Bugs List wrote:
> must_betrue is false for the query bellow
One of those is a bigint, the other is a double expression that is
probably very slightly different from the integer you're comparing it to.
What is the result of the date_part(...)-time?
--