Re: Counting days ... - Mailing list pgsql-sql

From Frank Bax
Subject Re: Counting days ...
Date
Msg-id 47DAA330.8070409@sympatico.ca
Whole thread Raw
In response to Re: Counting days ...  (Aarni Ruuhimäki <aarni@kymi.com>)
Responses Re: Counting days ...  (Aarni Ruuhimäki <aarni@kymi.com>)
List pgsql-sql
Aarni Ruuhimäki wrote:
> Thanks Frank,
> 
>>> a    start_day before period_start, end_day before period_start
> 
> This I don't have to care about as it is not in the period we are looking at.
> 
>>> b    start_day = period_start, end_day = period_start
> 
> Is zero days/nights, ignored. Not even possible to insert in the application. 
> end_day must be greater than start_day.


You should still consider rows that are "out of range" or "zero nights" 
in your test cases to make sure your report processes them correctly.


pgsql-sql by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Counting days ...
Next
From: PostgreSQL Admin
Date:
Subject: DB Design