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.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
