RE: Triggers - temporal

Julian,

Perhaps you could create a table with a timestamp field and 1 record.  Then
have a (perl/python/etc...) script running under a cron job update the
record.  Setup your trigger to run when the record is updated.

dale.sykora@compaq.com

-----Original Message-----
From: julian cowans [mailto:jcowans@hotmail.com]
Sent: Thursday, July 27, 2000 11:54 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Triggers - temporal


Is it possible to trigger certain events at pre-defined times? I am using
version 6.5.2, which suggests triggers can only be kicked off with a
<INSERT|UPDATE|DELETE> sql command.

Thanks, Julian
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com