Search Postgresql Archives

Re: 8.3: timestamp subtraction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
 
On 8.2 this comparision is also not true:
 
select '240:0:0.3'::interval = '10 0:0:0.3'::interval;
 
But without milliseconds it's true.
 
Is this also because interval is represented internally as a floating point value?
 
On 8.3 this test does not fail.
 
Best regards,
Otto

2009/5/23 Havasvölgyi Ottó <havasvolgyi.otto@xxxxxxxxx>
Thanks.
I tested the standard Win32 distribution of 8.3.6.
The same happens on 8.2. But on 8.0 it works.
 
When I don't use milliseconds, then it works.
 
Will 8.4 work fine on Win32 again?
 
Thanks,
Otto
 


2009/5/23 Ludwig Kniprath <ludwig@xxxxxxxxxxxxx>

Scott Marlowe schrieb:

On Sat, May 23, 2009 at 7:18 AM, Christophe <xof@xxxxxxxxxxxx> wrote:
 
On May 23, 2009, at 9:13 AM, Daniel Verite wrote:
   
I don't know why this query returns false:
SELECT '20040506 070809.010000'::timestamp(6) - '20010203
040506.007000'::timestamp(6) = '1188 day 3 hour 3 minute 3 second 3
millisecond'::interval;
If I just subtract the two timestamps, its result is the interval I
specified.
What may cause this?
       
It works for me:

test=> SELECT '20040506 070809.010000'::timestamp(6) -
'20010203 040506.007000'::timestamp(6)=
'1188 day 3 hour 3 minute 3 second 3 millisecond'::interval;
?column? ----------
t
(1 row)
     
Could this be due to the OP's build of PG using floating point timestamps?
   

That's what I'm thinking
Me too, a testquery-result on a Windows-System with version "PostgreSQL 8.3.0, compiled by Visual C++ build 1400":

SELECT ('20040506 070809.010000'::timestamp(6) - '20010203 040506.007000'::timestamp(6) - '1188 day 3 hour 3 minute 3 second 3 millisecond'::interval) * 1e10;

=> -00:01:28.220986


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux