pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Oliver Elphick <olly@lfix.co.uk>
To: josh@agliodbs.com
Cc: pgsql-sql@postgresql.org
Subject: Re: A proposal for Interval Math
Date: 19 May 2002 21:58:03 +0100
Message-ID: <1021841886.1401.56.camel@linda> (raw)
In-Reply-To: <200205191336.10383.josh@agliodbs.com>
References: <200205191336.10383.josh@agliodbs.com>

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
      things which God hath prepared for them that love 
      him."      I Corinthians 2:9 

Attachments:

  signature.asc (application/pgp-signature, 188B) download

view thread (7+ messages)  latest in thread

Message-ID: <1021841886.1401.56.camel@linda>
Permalink:  ../1021841886.1401.56.camel@linda/
Also on:    postgresql.org/message-id/1021841886.1401.56.camel@linda

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: olly@lfix.co.uk, josh@agliodbs.com
  Subject: Re: A proposal for Interval Math
  In-Reply-To: <1021841886.1401.56.camel@linda>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox