Skip site navigation (1) Skip section navigation (2)

Re: Counting days ...

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Counting days ...
Date: 2008-03-14 16:09:20
Message-ID: 47DAA330.8070409@sympatico.ca (view raw or flat)
Thread:
Lists: 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.

In response to

Responses

pgsql-sql by date

Next:From: PostgreSQL AdminDate: 2008-03-14 16:45:28
Subject: DB Design
Previous:From: Steve CrawfordDate: 2008-03-14 15:59:49
Subject: Re: Counting days ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group