From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Christophe <xof(at)thebuild(dot)com> |
Cc: | Pg - General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 8.3: timestamp subtraction |
Date: | 2009-05-23 16:09:03 |
Message-ID: | dcc563d10905230909w6a0a8f0flc6ba1ef45013917a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ludwig Kniprath | 2009-05-23 16:42:20 | Re: 8.3: timestamp subtraction |
Previous Message | Christophe | 2009-05-23 13:18:58 | Re: 8.3: timestamp subtraction |