X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B32B49DCA89 for ; Wed, 1 Mar 2006 19:10:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28230-09 for ; Wed, 1 Mar 2006 19:10:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 6B3F79DCA19 for ; Wed, 1 Mar 2006 19:10:49 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 06CD530C3A; Thu, 2 Mar 2006 00:10:51 +0100 (MET) From: Mark Dilger X-Newsgroups: pgsql.hackers Subject: Re: [SQL] Interval subtracting Date: Wed, 01 Mar 2006 15:10:18 -0800 Organization: Hub.Org Networking Services Lines: 10 Message-ID: <440629DA.6050504@markdilger.com> References: <200603012302.k21N2Hm04879@candle.pha.pa.us> <16750.1141254462@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Tom Lane User-Agent: Mozilla Thunderbird 1.0 (X11/20050130) X-Accept-Language: en-us, en In-Reply-To: <16750.1141254462@sss.pgh.pa.us> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-hackers@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.099 required=5 tests=[AWL=0.099] X-Spam-Score: 0.099 X-Spam-Level: X-Archive-Number: 200603/80 X-Sequence-Number: 80478 Tom Lane wrote: > Well, the question is whether justify_days has a sane definition that is > different from this. Based on your example, I'm not seeing one. Backwards compatibility is probably more important than sanity. Let's just deprecate the existing functions and recommend that people use justify_interval(...). By not changing the existing functions we can avoid a certain amount of hell. mark