X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2C599545F2 for ; Sat, 5 Mar 2005 04:36:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13031-07 for ; Sat, 5 Mar 2005 04:36:22 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 18C3B544EE for ; Sat, 5 Mar 2005 04:36:21 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j254aKnS014001; Fri, 4 Mar 2005 23:36:21 -0500 (EST) To: Andrew Hammond Cc: pgsql-sql@postgresql.org Subject: Re: date - date returns integer? In-reply-to: <4228CC16.7020900@ca.afilias.info> References: <4228CC16.7020900@ca.afilias.info> Comments: In-reply-to Andrew Hammond message dated "Fri, 04 Mar 2005 15:59:02 -0500" Date: Fri, 04 Mar 2005 23:36:20 -0500 Message-ID: <14000.1109997380@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.248 tagged_above=0 required=5 tests=AWL, INFO_TLD X-Spam-Level: X-Archive-Number: 200503/75 X-Sequence-Number: 20554 Andrew Hammond writes: > Should date - date return type integer, not interval? If we made it return interval then there would be all sorts of timezone dependencies introduced (think about DST crossings) ... which is generally something you don't want to think about when doing date arithmetic. I think the definitions of these operators are fine. regards, tom lane