Re: pgsql: Fix (hopefully for the last time) problems with datetime values - Mailing list pgsql-committers

From Larry Rosenman
Subject Re: pgsql: Fix (hopefully for the last time) problems with datetime values
Date
Msg-id 6FDBEE93-8D96-4D70-9E41-4FB625CF726C@lerctr.org
Whole thread Raw
In response to Re: pgsql: Fix (hopefully for the last time) problems with datetime values  (Michael Fuhr <mike@fuhr.org>)
Responses Re: pgsql: Fix (hopefully for the last time) problems with datetime values
List pgsql-committers
On Oct 9, 2005, at 1:56 PM, Michael Fuhr wrote:

> On Sun, Oct 09, 2005 at 02:21:47PM -0300, Tom Lane wrote:
>
>> Fix (hopefully for the last time) problems with datetime values
>> displaying
>> like '23:59:60' because of fractional-second roundoff problems.
>> Trying
>> to control this upstream of the actual display code was hopeless;
>> the right
>> way is to explicitly round fractional seconds in the display code
>> and then
>> refigure the results if the fraction rounds up to 1.  Per bug #1927.
>>
>
> This change causes my FreeBSD 4.11-STABLE box and a couple of
> FreeBSD 6
> members of the buildfarm to fail while building ecpg:
>
> timestamp.c: In function `timestamp2tm':
> timestamp.c:195: `INT_MAX' undeclared (first use in this function)
>
> Including <limits.h> in src/interfaces/ecpg/pgtypeslib/timestamp.c
> fixes the problem.

firefly (my UnixWare box as well) dies with this.

LER

>
> --
> Michael Fuhr
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>

--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 214-351-4152                 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611



pgsql-committers by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: pgsql: Fix (hopefully for the last time) problems with datetime values
Next
From: Michael Fuhr
Date:
Subject: Re: pgsql: Fix (hopefully for the last time) problems with datetime values