[SQL] Yearly Archival System Using PostgreSQL

2005-07-14 Thread Vivek
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 functio

Re: [SQL] Yearly Archival System Using PostgreSQL

2005-07-15 Thread Michael Fuhr
On Thu, Jul 14, 2005 at 02:24:17AM -0700, Vivek wrote: > 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 sam