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 4926F9DC9AD for ; Thu, 2 Mar 2006 12:13:13 -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 98870-06 for ; Thu, 2 Mar 2006 12:13:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 0E1AA9DC99E for ; Thu, 2 Mar 2006 12:13:10 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Thu, 2 Mar 2006 16:13:10 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 02 Mar 2006 10:13:09 -0600 Subject: Re: [SQL] Interval subtracting From: Scott Marlowe To: Hannu Krosing Cc: pgsql-hackers@postgresql.org In-Reply-To: <1141281952.3737.17.camel@localhost.localdomain> References: <200603012027.k21KRk423759@candle.pha.pa.us> <1141245396.18820.16.camel@state.g2switchworks.com> <1141281952.3737.17.camel@localhost.localdomain> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Message-Id: <1141315989.18820.56.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 02 Mar 2006 10:13:09 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.151 required=5 tests=[AWL=0.150, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.151 X-Spam-Level: X-Archive-Number: 200603/123 X-Sequence-Number: 80521 On Thu, 2006-03-02 at 00:45, Hannu Krosing wrote: > =C3=9Chel kenal p=C3=A4eval, K, 2006-03-01 kell 14:36, kirjutas Scott Mar= lowe: >=20 > > > But it isn't '-2 months, -1 day'. I think what you are saying is wha= t I > > > am saying, that we should make the signs consistent. > >=20 > > Pretty much. It just seems wrong to have different signs in what is > > essentially a single unit. > >=20 > > 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. >=20 > But we do say both "quarter past three" (3 hours 15 min) and "quarter to > four" (4 hours -15 min) when talking about time. But the military says 1515 or 1545 or 0315 or 0345, because if they get the time wrong they shell the wrong place and kill their own soldiers.=20 I.e. getting it right is important to them. So they use exact language. I prefer the more exact way.