Postgres Pro
Downloads
Home   >   mailing lists

Re: time interval math - Mailing list pgsql-sql

From Jasen Betts
Subject Re: time interval math
Date
Msg-id jh4mmj$7pm$2@reversiblemaps.ath.cx
Whole thread Raw
In response to time interval math  ("Edward W. Rouse" <erouse@comsquared.com>)
List pgsql-sql
Tree view 
On 2012-02-09, Edward W. Rouse <erouse@comsquared.com> wrote:

>> the operation abs() is meaninless on the type interval
>> eg: what is abs( '1 month - 32 days + 24 hours'::interval )
>
> If you need to add 30 intervals together, then +- is not meaningless. 

if you stop reading after one line you miss the answer.


-- 
⚂⚃ 100% natural

pgsql-sql by date:

Previous
From: Philip Couling
Date:
Subject: Re: Calling Postgresql Function to delete user data
Next
From: John Fabiani
Date:
Subject: foreign key is it a real key