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.
In response to
pgsql-sql by date
|Next:||From: PostgreSQL Admin||Date: 2008-03-14 16:45:28|
|Subject: DB Design|
|Previous:||From: Steve Crawford||Date: 2008-03-14 15:59:49|
|Subject: Re: Counting days ...|