Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f76Lx3656350 for ; Mon, 6 Aug 2001 17:59:03 -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 97649; Mon, 06 Aug 2001 14:59:00 -0700 From: "Josh Berkus" Subject: Re: Re: Data type confusion To: Tom Lane , "Josh Berkus" Cc: Allan Engelhardt , pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Mon, 06 Aug 2001 14:59:00 -0700 Message-ID: In-Reply-To: <24762.997134620@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200108/71 X-Sequence-Number: 4292 Tom, > Curiously enough, ANSI doesn't define an INTERVAL-divided-by-INTERVAL > function either. Also, it rather looks like ANSI adopted the > position > Peter E. expressed: > > Year-month intervals are mutually comparable only with other > year- > month intervals. [...] > Day-time intervals are mutually comparable only with other > day- > time intervals. [...] > Operations involving items of type datetime require that the > date- > time items be mutually comparable. Operations involving > items of > type interval require that the interval items be mutually > compara- > ble. Hmmm ... does this mean that I couldn't divide '1 year' by '1 week'? I can certaily see not allowing division of '1 year' by '28 seconds' as it spares us a whole bunch of calendar-generated fuzziness. It seems to me that: years,months,weeks,days / years,months,weeks,days is OK, and days,hours,minutes,seconds / days,hours,minutes,seconds is also easy, but years,months,weeks / hours,minutes,seconds is where we get in trouble. So I propose that we suppot the first two and disallow the third. Thus I think that we can adhere to the spec, while still providing the functionality developers want and avoiding a whole lot of '5 months 11 minutes' type headaches. -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco