Hi Ric, You could use a cron job that executes a SQL statement to delete the old records. :-) Regards and best wishes, Justin Clift Ric Mañalac wrote: > > hello, > > how can i make postgres to execute a query automatically during > scheduled times? > > here's my situation. i store records on a table. these records should be > removed 1 day after they were created. > > thanks. > > ric > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
