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 3BA099DC822 for ; Wed, 1 Mar 2006 19:07:56 -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 28712-08 for ; Wed, 1 Mar 2006 19:07:58 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 28CC49DC821 for ; Wed, 1 Mar 2006 19:07:53 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id A5CB730C3A; Thu, 2 Mar 2006 00:07:56 +0100 (MET) From: Mark Dilger X-Newsgroups: pgsql.hackers Subject: Re: [SQL] Interval subtracting Date: Wed, 01 Mar 2006 15:07:22 -0800 Organization: Hub.Org Networking Services Lines: 9 Message-ID: <4406292A.1050403@markdilger.com> References: <16569.1141253147@sss.pgh.pa.us> <200603012302.k21N2Hm04879@candle.pha.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: Bruce Momjian User-Agent: Mozilla Thunderbird 1.0 (X11/20050130) X-Accept-Language: en-us, en In-Reply-To: <200603012302.k21N2Hm04879@candle.pha.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.097 required=5 tests=[AWL=0.097] X-Spam-Score: 0.097 X-Spam-Level: X-Archive-Number: 200603/78 X-Sequence-Number: 80476 Bruce Momjian wrote: > If we do that, we should just call it justify_interval(). I am thinking > this is the direction to go, and for people who want more control they > use the justify_hours and justify_days, and those are left unchanged. I agree. Let's leave the existing functions alone. I can roll-up the changes made so far into a new function as Bruce suggests. mark