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 F02539DCAA7 for ; Wed, 1 Mar 2006 19:45:02 -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 33610-08 for ; Wed, 1 Mar 2006 19:45:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.markdilger.com (or-65-40-225-74.sta.sprint-hsd.net [65.40.225.74]) by postgresql.org (Postfix) with ESMTP id 53EE49DC982 for ; Wed, 1 Mar 2006 19:44:59 -0400 (AST) Received: from [192.168.2.6] ([192.168.2.6]) (TLS: TLSv1/SSLv3,256bits,AES256-SHA) by mail.markdilger.com with esmtp; Wed, 01 Mar 2006 15:49:52 -0800 id 00020D65.44063320.00004141 Message-ID: <440631BE.2050501@markdilger.com> Date: Wed, 01 Mar 2006 15:43:58 -0800 From: Mark Dilger User-Agent: Mozilla Thunderbird 1.0 (X11/20050130) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane CC: pgsql-hackers@postgresql.org, Bruce Momjian Subject: Re: [SQL] Interval subtracting References: <44061060.8080407@markdilger.com> <200603012145.k21LjRX11928@candle.pha.pa.us> <44061790.1040302@markdilger.com> <44062073.9010803@markdilger.com> <4406262B.4000509@markdilger.com> <16936.1141255433@sss.pgh.pa.us> In-Reply-To: <16936.1141255433@sss.pgh.pa.us> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.09 required=5 tests=[AWL=0.090] X-Spam-Score: 0.09 X-Spam-Level: X-Archive-Number: 200603/86 X-Sequence-Number: 80484 Tom Lane wrote: > Mark Dilger writes: > >>This overall design seems more flexible than Tom's recent post in which he >>stated that justify_days should call justify_hours internally. > > > AFAIR I said the exact opposite. > > regards, tom lane Tom Lane also wrote: > assumption), but justify_days should be changed to be effectively a > combination of both functions --- that is, it should fix all three > fields using both the 30days and the 24hours assumptions. Then it could > guarantee that all come out with the same sign. How is changing justify days so that it touches the hours field different from having justify_days call justify_hours? mark