Re: A proposal for Interval Math - Mailing list pgsql-sql

From Oliver Elphick
Subject Re: A proposal for Interval Math
Date
Msg-id 1021841886.1401.56.camel@linda
Whole thread Raw
In response to A proposal for Interval Math  (Josh Berkus <josh@agliodbs.com>)
Responses Re: A proposal for Interval Math
List pgsql-sql
On Sun, 2002-05-19 at 21:36, Josh Berkus wrote:

> Ah, you ask, but what about '7 months' / '3 days'?  This requires the addtion
> of "Interval Rounding" to the Postgresql system.

As I understand the standard, this is an illegal operation, because the
two intervals are of incompatible types and a meaningful result is not
possible.  I do not think anyone should try to implement it.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
    "But as it is written, Eye hath not seen, nor ear      heard, neither have entered into the heart of man, the
thingswhich God hath prepared for them that love      him."      I Corinthians 2:9  

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: A proposal for Interval Math
Next
From: Josh Berkus
Date:
Subject: Re: A proposal for Interval Math