Re: date update check - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: date update check
Date
Msg-id 20050504193235.GA7741@wolff.to
Whole thread Raw
In response to date update check  ("sZEJTAN" <szejtan@poczta.onet.pl>)
List pgsql-novice
On Wed, May 04, 2005 at 20:57:26 +0200,
  sZEJTAN <szejtan@poczta.onet.pl> wrote:
> Hullo
>
> Is it possible to create trigger on date update? For example automatically
> alter sbd's age every day;-)

The normal solution to update things when the day changes would be to set up a
cron job to do this.

However, for ages you should be storing a birthdate and not an age.

pgsql-novice by date:

Previous
From: "sZEJTAN"
Date:
Subject: date update check
Next
From: John DeSoi
Date:
Subject: Re: Output of PL/PGSQL?