| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Temporal Units |
| Date: | 2007-04-29 20:45:53 |
| Message-ID: | Pine.LNX.4.64.0704291344280.25310@salmo.appl-ecosys.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, 29 Apr 2007, Rich Shepard wrote:
> How does one define 'shift' with intervals? 0.33 DAY?
On further reflection, I understand how to make the interval 'day' work by
comparing the current timestamp with the month and hour. If there's no
record within the necessary range, a message is e-mailed to the client
noting the deficiency.
Thanks all,
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vinay Sajip | 2007-04-29 20:55:13 | Re: pg_dump without psql rights |
| Previous Message | Rich Shepard | 2007-04-29 20:33:37 | Re: Temporal Units |