I am developing a database system using PostgreSQL in which I should be able to delete redundant records once a year (Time specified by the user). THe redundant records should be inserted into the archive table which is part of the same database.
Is this possible in pgsql? Can I program a function in SQL or a trigger to fire when the computer switches on say Jan 1 of every year? Will be grateful if anybody could point me in the right direction. Vivek ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
