Re: Temporal Units - Mailing list pgsql-general

From Rich Shepard
Subject Re: Temporal Units
Date
Msg-id Pine.LNX.4.64.0704291332480.25310@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Temporal Units  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Temporal Units  (Rich Shepard <rshepard@appl-ecosys.com>)
Re: Temporal Units  (Listmail <lists@peufeu.com>)
List pgsql-general
On Sun, 29 Apr 2007, Martijn van Oosterhout wrote:

> Then I'm afraid you havn't indicated your requirements properly. All I can
> see is that the interval type does exactly what you want. It can store
> days, weeks, months or any combination thereof. You can multiply them and
> add them to dates and all works as expected.

   How does one define 'shift' with intervals? 0.33 DAY?

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: Martijn van Oosterhout
Date:
Subject: Re: Temporal Units
Next
From: Rich Shepard
Date:
Subject: Re: Temporal Units