Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f76Ktl628860 for ; Mon, 6 Aug 2001 16:55:47 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 97584; Mon, 06 Aug 2001 13:55:43 -0700 From: "Josh Berkus" Subject: Re: Re: Data type confusion To: Allan Engelhardt , Josh Berkus , pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Mon, 06 Aug 2001 13:55:43 -0700 Message-ID: In-Reply-To: <3B6EFA63.FA7326EB@cybaea.com> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200108/67 X-Sequence-Number: 4288 Allan, > I see now what you are trying to do. It sort of makes sense, but I'm > still really reluctant to give (semantic or otherwise) meaning to > "yesterday divided by tomorrow" ..... I don't agree. Consider, for example, this statement: '30 weeks ago'::INTERVAL / '2 weeks'::INTERVAL = -15 Just as -30 / 2 = -15 To phrase the equation above: "How many two week periods is thirty weeks ago? Minus fifteen, or fifteen ago." This makes perfect sense to me. > It seems to me that such a function would be more generally useful > than the division of intervals. What you really want to do is not to > divide intervals, but to express them in different time units. Or am > I missing something (again)?