Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f75MjQ610775 for ; Sun, 5 Aug 2001 18:45:26 -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.4/8.11.4) with ESMTP id f75MjLY07083; Sun, 5 Aug 2001 18:45:21 -0400 (EDT) To: "Josh Berkus" cc: pgsql-sql@postgresql.org Subject: Re: Data type confusion In-reply-to: References: Comments: In-reply-to "Josh Berkus" message dated "Sun, 05 Aug 2001 15:05:46 -0700" Date: Sun, 05 Aug 2001 18:45:20 -0400 Message-ID: <7080.997051520@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200108/52 X-Sequence-Number: 4273 "Josh Berkus" writes: > If > INTERVAL / INTEGER = INTERVAL Actually the operator appears to be INTERVAL / FLOAT8. > then why does > INTERVAL / INTERVAL = ERROR? Because no one got around to creating an INTERVAL / INTERVAL operator. There are plenty of such gaps in our operator set... > Shouldn't > INTERVAL / INTERVAL = INTEGER? I'd think the output should be FLOAT8, myself, since the result could be fractional. Anyway, the generic response to such questions is "feel free to code it up and submit a patch". regards, tom lane