Hi!
A further tweak; add the following to the WHERE clause:
AND EXTRACT(DOW FROM times.period) != 0
I changed it to isodow to work in any locale.
Your solution is more readable but Erwin answer in SO looks more optimized.
I have 10 workes and 1 month reservation with 15 minute offsess from 8 to
20:00, so perfomance is hopafully not an issue. Which to use ?
Using current_date in check constraint causes database restore failure.
not valid should be added or this check should be moved to holydays check
trigger.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
