Re: triggers on date?

this is for a billing system, at this point it's a toss-up b/w the
following:

1. a script grabs clients which need billing on a nightly basis
2. a script grabs clients which need billing for a particular time
interval (every hour, ever two hours etc...).

what methods are used for making this close to real-time - constant
polling?

thanks!
-lev

On 2 Jul 2002, Jason Earl wrote:

>
> If it only needs to be /fairly/ realtime, then you could use cron to
> fire a script every minute. Otherwise you could write an external
> long-running program that listens for notifies.
>
> Jason
>
> Lev Lvovsky <lists1(at)sonous(dot)com> writes:
>
> > is it possible to create a trigger when the system time has reached the
> > date of a particular record? I know this is possible with an external
> > script, but I'm not quite sure how to go about making it fairly
> > real-time...
> >
> > thanks!
> > -lev
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
>

--
personal site :: www.sonous.com
rave site :: raves.sonous.com
I'm a DJ! site :: djkgb.sonous.com

"...is the best show on television. Its cooler than the other side of the
pillow." -Kevin King