> I would like to know if can have a time based > trigger, for example a procedure that could be run everyday at say 10 in > the night. Thanking you, Isn't this what cron is for? Just set it up so it invokes pg with a command line query. Chris ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster