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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

  From Date Subject
Next Message PostgreSQL Admin 2008-03-14 16:45:28 DB Design
Previous Message Steve Crawford 2008-03-14 15:59:49 Re: Counting days ...