Re: 8.3: timestamp subtraction

    Havasvölgyi Ottó 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)

test=> select version();
                          version

-----------------------------------------------------------------------
-----------------------------
 PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real
(Ubuntu 4.3.2-1ubuntu11) 4.3.2
(1 row)

Best regards,
--
 Daniel
 PostgreSQL-powered mail user agent and storage:
 http://www.manitou-mail.org