Re: [HACKERS] Interval subtracting - Mailing list pgsql-sql

From PFC
Subject Re: [HACKERS] Interval subtracting
Date
Msg-id op.s535oruacigqcu@apollo13
Whole thread Raw
In response to Re: [HACKERS] Interval subtracting  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-sql
> For same reasons, i.e. a need for precision, I find it hard to accept
> the idea of mixing positive and negative units in the same interval.
> The plus or minus sign should be outside of the interval.
The interval data type is really useful. I see no reason to restrict its  
usefulness with an arbitrary constraint. Date arithmetic is treacherous  
and INTERVAL is a lifesaver.
Forcing a global sign on the interval would break interval arithmetic.How would you compute '1 month'::interval - '1
week'::interval?
 


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Errors ignored on restore
Next
From: Josh Berkus
Date:
Subject: Is there any way to stop triggers from cycling?