Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f551PGE04527 for ; Mon, 4 Jun 2001 21:25:16 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f551PCR09355; Mon, 4 Jun 2001 21:25:12 -0400 (EDT) To: "Josh Berkus" cc: pgsql-sql@postgresql.org Subject: Re: Huh? Data typing bug? In-reply-to: References: Comments: In-reply-to "Josh Berkus" message dated "Mon, 04 Jun 2001 17:33:15 -0700" Date: Mon, 04 Jun 2001 21:25:11 -0400 Message-ID: <9352.991704311@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200106/31 X-Sequence-Number: 3234 "Josh Berkus" writes: > I just subtracted two dates and got an INT4, rather than the INTERVAL I > was expecting. What goes on here? IIRC, number of days (as an int) is what that's supposed to produce. If that's not what you wanted, maybe you ought to cast the dates to timestamp or some such. regards, tom lane