From: Frank Bax <fbax@sympatico.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Counting days ...
Date: Fri, 14 Mar 2008 12:09:20 -0400
Message-ID: <47DAA330.8070409@sympatico.ca> (raw)
In-Reply-To: <200803141713.40589.aarni@kymi.com>
References: <200803132025.27821.aarni@kymi.com>
<47DA8108.1020104@sympatico.ca>
<47DA848A.9000700@sympatico.ca>
<200803141713.40589.aarni@kymi.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: fbax@sympatico.ca
Subject: Re: Counting days ...
In-Reply-To: <47DAA330.8070409@sympatico.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox