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
