Re: date update check

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: sZEJTAN <szejtan(at)poczta(dot)onet(dot)pl>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: date update check
Date: 2005-05-04 19:32:35
Message-ID: 20050504193235.GA7741@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, May 04, 2005 at 20:57:26 +0200,
sZEJTAN <szejtan(at)poczta(dot)onet(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Keith Worthington 2005-05-04 20:44:00 date interval
Previous Message John DeSoi 2005-05-04 19:15:14 Re: Output of PL/PGSQL?