Re: A proposal for Interval Math

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: josh(at)agliodbs(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: A proposal for Interval Math
Date: 2002-05-19 20:58:03
Message-ID: 1021841886.1401.56.camel@linda
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)Elphick(at)lfix(dot)co(dot)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
things which God hath prepared for them that love
him." I Corinthians 2:9

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-05-19 21:21:05 Re: A proposal for Interval Math
Previous Message Edipo E. F. Melo 2002-05-19 20:43:21 Re: Casting timestamp