Yearly Archival System Using PostgreSQL

Поиск
Список
Период
Сортировка
От Vivek
Тема Yearly Archival System Using PostgreSQL
Дата
Msg-id 1121333057.572963.320670@z14g2000cwz.googlegroups.com
обсуждение исходный текст
Ответы Re: Yearly Archival System Using PostgreSQL  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-sql
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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Luca Pireddu
Дата:
Сообщение: problem (bug?) with "in (subquery)"
Следующее
От: Dhanashree
Дата:
Сообщение: difference between all RDBMSs