Re: Is there anyway to...

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