... - Mailing list pgsql-sql

From rhema@bhasin.co.in
Subject ...
Date
Msg-id 20020523112720.23101.qmail@vmail1.ebhasin.com
Whole thread Raw
Responses Re:  ("Rajesh Kumar Mallah." <mallah@trade-india.com>)
Re:  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Tille, Andreas"
Date:
Subject: Re: Turning column into row
Next
From: Gabriel Dovalo Carril
Date:
Subject: Functions with dynamic queries