Message-ID: <52714E3E.2080306@archidevsys.co.nz>
Date: Thu, 31 Oct 2013 07:21:50 +1300
From: Gavin Flower <GavinFlower@archidevsys.co.nz>
Organization: ArchiDevSys
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.0
MIME-Version: 1.0
To: "Craig R. Skinner" <skinner@britvault.co.uk>, pgsql-sql@postgresql.org
Subject: Re: Number of days in a tstzrange?
References: <20131024204638.GA31094@teak.britvault.co.uk>
 <219E3855-325F-4B55-A23B-DA014FBDA2BF@excoventures.com>
 <20131029113450.GA26067@teak.britvault.co.uk>
 <20131030104015.GA12587@teak.britvault.co.uk>
In-Reply-To: <20131030104015.GA12587@teak.britvault.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 30/10/13 23:40, Craig R. Skinner wrote:
> On 2013-10-29 Tue 11:34 AM |, Craig R. Skinner wrote:
>> 	-- if a subscription is ceased same day it's started,
>> 	-- that day is still chargable, so bump it
>> 	IF billable_days < 1
>> 	THEN
>> 		billable_days := 1;
>> 	END IF;
>> 	...
>> 	...
>>
> This is more accurate:
>
> 	-- If a subscription billing_period ends part way through a day,
> 	IF upper(billable_item.billable_period)::time <> time 'allballs'
> 	THEN
> 		-- That partial day is still chargable, so bump it
> 		billable_days := billable_days + 1;
> 	END IF;
>
>
>
even for 1 second over???

I would expect any court of law to set a higher threshold!


Cheers,
Gavin


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql