Re: Re: Interval bug - Mailing list pgsql-bugs

From Thomas Lockhart
Subject Re: Re: Interval bug
Date
Msg-id 3A5E729C.AB229740@alumni.caltech.edu
Whole thread Raw
In response to Re: Re: Interval bug  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
> ... Should we print the "days" +/-
> sign only when it is not the same as the "year" sign?  Seems like the
> way to go.

It isn't quite that easy, but you have the right idea. My new code omits
signs unless there is a negative field value, then all subsequent fields
are signed.

That seems to be less ambiguous. fwiw, the traditional "Postgres format"
never was right in this regard (though internal calculations were done
correctly).

                    - Thomas

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Query Problem!!
Next
From: Bruce Momjian
Date:
Subject: Re: JDBC PreparedStatement.setMaxRows() affects other objects intantiated from this class and it's parent class