Re: [BUGS] Postgres storing time in strange manner - Mailing list pgsql-novice

From Tom Lane
Subject Re: [BUGS] Postgres storing time in strange manner
Date
Msg-id 20817.1032239730@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] Postgres storing time in strange manner  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-novice
Ron Johnson <ron.l.johnson@cox.net> writes:
> On Sun, 2002-09-15 at 03:57, Casey Allen Shobe wrote:
>> I don't have a clue why it's doing this - has anyone else seen this sort
>> of behavior, or know why it might be doing it?  It shows times wrong, for
>> instance, it shows 00:04:60 where it should show 00:05:00.  See below:

> In a subsequent post, Tom Lane said that 7.2.2 fixed the problem,
> but a reply post from the original poster says that he is, in fact,
> using 7.2.2...

Further investigation showed that he'd built Postgres with -ffast-math
gcc option, which is well known to break the datetime rounding code :-(

            regards, tom lane

pgsql-novice by date:

Previous
From: Ron Johnson
Date:
Subject: Re: [BUGS] Postgres storing time in strange manner
Next
From: Wim
Date:
Subject: Still big problems with pg_dump!