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