Re: time interval math

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: time interval math
Date: 2012-02-11 03:18:43
Message-ID: jh4mmj$7pm$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2012-02-09, Edward W. Rouse <erouse(at)comsquared(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rehan Saleem 2012-02-11 19:53:37 Calling Postgresql Function to delete user data
Previous Message David Johnston 2012-02-10 16:08:11 Re: update column with multiple values