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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
