Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char)
Date
Msg-id D80BBF3A-8C07-4337-8DD9-B4B713247C04@seespotcode.net
Whole thread Raw
In response to timestamp subtraction (was Re: formatting intervals with to_char)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Oct 6, 2006, at 1:50 , Tom Lane wrote:

> I'm tempted to propose that we remove the justify_hours call, and tell
> anyone who really wants the old results to apply justify_hours() to  
> the
> subtraction result for themselves.  Not sure what the fallout would  
> be,
> though.

I'm tempted to support such a proposal. Is this something that we'd  
want to do for 8.2? There are some interval range checking fixes I'm  
working on for 8.3. Perhaps this could be rolled into that as well?  
Then again, range checking and behavior are two separate things.  
Considering how late it is in the cycle, perhaps the change in  
behavior should come in 8.3.

Michael Glaesemann
grzm seespotcode net




pgsql-sql by date:

Previous
From: "Hector Villarreal"
Date:
Subject: Re: Assigning a timestamp without timezone to a timestamp
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char)