Postgres Pro
Downloads
Home   >   mailing lists

Re: storing repeating dates / events - Mailing list pgsql-general

From Jorge Godoy
Subject Re: storing repeating dates / events
Date
Msg-id 200809061525.48631.jgodoy@gmail.com
Whole thread Raw
In response to Re: storing repeating dates / events  ("rkmr.em@gmail.com" <rkmr.em@gmail.com>)
List pgsql-general
Tree view 
Em Saturday 06 September 2008 14:34:22 rkmr.em@gmail.com escreveu:
> yes i am trying to build a alerting system where events will repeat
> weekly/monthly/annually
>
> what is the best way to store this kind of information in postgres?

Use timestamps.  And model your application with them.

--
Jorge Godoy      <jgodoy@gmail.com>
Attachment

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Can I truncate statements in the log?
Next
From: Bruce Momjian
Date:
Subject: Re: Subqueries in Check() -- Still Intentionally Omitted?