Re: storing repeating dates / events

From: Jorge Godoy <jgodoy(at)gmail(dot)com>
To: "rkmr(dot)em(at)gmail(dot)com" <rkmr(dot)em(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: storing repeating dates / events
Date: 2008-09-06 18:25:41
Message-ID: 200809061525.48631.jgodoy@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Em Saturday 06 September 2008 14:34:22 rkmr(dot)em(at)gmail(dot)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(at)gmail(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2008-09-06 19:30:57 Re: Subqueries in Check() -- Still Intentionally Omitted?
Previous Message Bruce Momjian 2008-09-06 17:38:00 Re: Can I truncate statements in the log?