Re: Temporal Units

[Rich Shepard <rshepard(at)appl-ecosys(dot)com>]

On Mon, 30 Apr 2007, John D. Burger wrote:

> 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,

  That thread asked how to find business days between any two specified
dates. I would like to create a calendar table that includes business days,
holidays, Julianized dates, and other interesting tid-bits that are of value
in a business application. Then dates can be looked up in the table to learn
their attributes and the calculations don't need to be done each time.

  A Google search with the terms "sql calendar table" returns > 1.4 million
hits. They're almost all SQL Server, T-SQL, and similar. I am really
surprised at not finding a postgresql solution among all these (but I looked
only at the first 40 hits).

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863