On 11/2/06, louis gonzales <gonzales@linuxlouis.net> wrote:
> Hey Brian,
> Yeah I had considered this, using cron, I just feel like that is too dirty.
>
> Actually I didn't see Andreas' post, can someone forward that?
>
> I'm running this application on Solaris 9. Ultimately what I want to
> know is, is there something that is internal to postgresql that can be
> used that doesn't need external action, to make it do some task?
>
Your original scenario had an external action, instructor login. The
daily increment is the days since account creation.
Since we don't have triggers based on login, you maybe could tickle a
function from your front-end that would simply look for students with
account age > 30 and not paid whenever the instructor logs in.
Short of that, an OS based scheduler (AT, cron, etc.) is your only
choice I can think of