On 2009-05-23, Havasvölgyi Ottó <havasvolgyi.otto@xxxxxxxxx> wrote: > --0016364c779590a8c0046a9321b6 > Content-Type: text/plain; charset=ISO-8859-1 > Content-Transfer-Encoding: 7bit > > Hi, > > 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? floating point arithmetic. especially floats involving fractions. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
