Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id D3ABB475EC3
	for <pgsql-sql@postgresql.org>; Thu, 23 May 2002 07:39:33 -0400 (EDT)
Received: from vmail1.ebhasin.com (unknown [203.200.33.10])
	by postgresql.org (Postfix) with SMTP id C2A85475AD1
	for <pgsql-sql@postgresql.org>; Thu, 23 May 2002 07:34:45 -0400 (EDT)
Received: (qmail 23102 invoked by uid 89); 23 May 2002 11:27:20 -0000
Message-ID: <20020523112720.23101.qmail@vmail1.ebhasin.com>
From: rhema@bhasin.co.in
To: pgsql-sql@postgresql.org
Date: Thu, 23 May 2002 11:27:20 GMT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200205/252
X-Sequence-Number: 7887

hello,
 I need to know if there are any database event triggers
in postgres like i want the trigger to run periodically(every day just like 
crontab on unix), i need to delete the records in a table automatically 
after a period of say 90 days. 

It is possible to create trigger on table before insert or update but if 
there are no insertions or updations on the table, the record will remain in 
the database.
looking forward for the suggestions. 

Thanx in advance
Hema 

_____________________________________
Powered by EBHASIN V-Mail Service.
Visit http://www.ebhasin.com