Re: Number of days in a tstzrange? - Mailing list pgsql-sql

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;