Re: triggers on date?

With cron you could make your script "grab clients" every minute.  If
you need even smaller increments between checks then the thing to do
would be to write a long running program.

Jason

Lev Lvovsky <lists1@sonous.com> writes:

> 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@sonous.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@postgresql.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