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 92D1F9DCABF for ; Thu, 2 Mar 2006 02:45:58 -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 09277-03 for ; Thu, 2 Mar 2006 02:45:58 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.skype.net (mail.skype.net [195.215.8.149]) by postgresql.org (Postfix) with ESMTP id 7DFD59DCABD for ; Thu, 2 Mar 2006 02:45:56 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.skype.net (Postfix) with ESMTP id CA4754DD94; Thu, 2 Mar 2006 07:45:55 +0100 (CET) Received: from [10.10.10.6] (217-159-136-226-dsl.kt.estpak.ee [217.159.136.226]) by mail.skype.net (Postfix) with ESMTP id 228CC4DD6D; Thu, 2 Mar 2006 07:45:53 +0100 (CET) Subject: Re: [SQL] Interval subtracting From: Hannu Krosing To: Scott Marlowe Cc: pgsql-hackers@postgresql.org In-Reply-To: <1141245396.18820.16.camel@state.g2switchworks.com> References: <200603012027.k21KRk423759@candle.pha.pa.us> <1141245396.18820.16.camel@state.g2switchworks.com> Content-Type: text/plain; charset=utf-8 Date: Thu, 02 Mar 2006 08:45:52 +0200 Message-Id: <1141281952.3737.17.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.067 required=5 tests=[AWL=0.067] X-Spam-Score: 0.067 X-Spam-Level: X-Archive-Number: 200603/99 X-Sequence-Number: 80497 Ühel kenal päeval, K, 2006-03-01 kell 14:36, kirjutas Scott Marlowe: > > But it isn't '-2 months, -1 day'. I think what you are saying is what I > > am saying, that we should make the signs consistent. > > Pretty much. It just seems wrong to have different signs in what is > essentially a single unit. > > We don't say 42 degrees, -12 minutes when measuring arc, do we? Then > again, maybe some folks do. It just seems wrong to me. But we do say both "quarter past three" (3 hours 15 min) and "quarter to four" (4 hours -15 min) when talking about time. --------------- Hannu