In-Reply-To: <21619.1160067054@sss.pgh.pa.us>
References: <4522EC42.1080500@refractions.net>
 <21619.1160067054@sss.pgh.pa.us>
Mime-Version: 1.0 (Apple Message framework v752.2)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <D80BBF3A-8C07-4337-8DD9-B4B713247C04@seespotcode.net>
Cc: gdavis@refractions.net, pgsql-sql@postgresql.org,
	pgsql-hackers@postgresql.org
Content-Transfer-Encoding: 7bit
From: Michael Glaesemann <grzm@seespotcode.net>
Subject: Re: [HACKERS] timestamp subtraction (was Re: formatting intervals
	with to_char)
Date: Fri, 6 Oct 2006 10:32:59 +0900
To: Tom Lane <tgl@sss.pgh.pa.us>


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