Re: BUG #1179: Time comparison fail

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,starteddatetime)))*1000-time
as Must_be_Zero,
mex2-# date_part('second',((starteddatetime)))*1000 as starteddatetime_s,
mex2-# date_part('second',((endeddatetime)))*1000 as endeddatetime_s,
mex2-# starteddatetime,
mex2-# endeddatetime
mex2-# from entry where not
date_part('second',(age(endeddatetime,starteddatetime)))*1000=time;
age | time | ?column? | must_be_zero | starteddatetime_s
| endeddatetime_s | starteddatetime | endeddatetime
--------------+------+----------+-----------------------+-------------------+-----------------+----------------------------+----------------------------
00:00:04.031 | 4031 | 4031 | -4.54747350886464e-13 | 51171 |
55202 | 2004-05-10 12:47:51.171-05 | 2004-05-10 12:47:55.202-05
00:00:04.094 | 4094 | 4094 | 4.54747350886464e-13 | 51171 |
55265 | 2004-05-10 12:47:51.171-05 | 2004-05-10 12:47:55.265-05
00:00:04.047 | 4047 | 4047 | -4.54747350886464e-13 | 32781 |
36828 | 2004-05-10 12:50:32.781-05 | 2004-05-10 12:50:36.828-05
00:00:02.047 | 2047 | 2047 | 2.27373675443232e-13 | 54171 |
56218 | 2004-05-10 14:10:54.171-05 | 2004-05-10 14:10:56.218-05
00:00:04.046 | 4046 | 4046 | 4.54747350886464e-13 | 5312 |
9358 | 2004-05-10 14:13:05.312-05 | 2004-05-10 14:13:09.358-05
(5 rows)

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail