Rich Shepard wrote:
I wonder if a workweek/holiday calendar table for PostgreSQL alreadyexists. If not I need to track down the procedure for creating one as Joe Celko references such a calendar in his books. I think that any schema thathas temporal components needs such a table.
There was a brief discussion of this just last week, with a few solutions suggested:
http://archives.postgresql.org/pgsql-general/2007-04/msg01098.php - John D. Burger MITRE