Re: 8.3: timestamp subtraction

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(at)kni-online(dot)de>

> Scott Marlowe schrieb:
>
>> On Sat, May 23, 2009 at 7:18 AM, Christophe <xof(at)thebuild(dot)com> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>