Re: Temporal Units - Mailing list pgsql-general

From Rich Shepard
Subject Re: Temporal Units
Date
Msg-id Pine.LNX.4.64.0705031810180.24593@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Temporal Units  (Lew <lew@nospam.lewscanon.com>)
List pgsql-general
On Wed, 2 May 2007, Lew wrote:

> The best solution I've encountered so far to this type of problem is to
> have a table of "days" with columns like isWeekday, isHoliday, julianDay,
> otherTidbit, ...
>
> Then you select or join the days within the interval of interest and
> factor out weekdays, or holidays, or whatever.

   Thank you, Lew.

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

pgsql-general by date:

Previous
From: "Jan Bilek"
Date:
Subject: Re: Password authentication failed
Next
From: Tom Lane
Date:
Subject: Re: Help tracking down error in postgres log