Is there anyway to...

From: louis gonzales <gonzales(at)linuxlouis(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Is there anyway to...
Date: 2006-11-02 18:14:22
Message-ID: 454A357E.6010409@linuxlouis.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-sql

Hello all,
Is there an existing mechanism is postgresql that can automatically
increment/decrement on a daily basis w/out user interaction? The use
case I'm considering is where a student is in some type of contract with
an instructor of some sort, and that contract puts a time limit on the
student requiring her to pay a fee by a certain day. IF that day comes
to pass - or a certain number of days elapse - and that payment
requirement hasn't been met, I want to trigger a function.

The one requirement I want to impose is, that no end user of the DB
application, needs to do anything to set the trigger, other than the
initialization of making the student of this type.

An example would be:
Day1 - Application user(typically the instructor) creates a profile for
a new student - John Doe, which sets a 30 day time limit for John Doe to
pay $100.00
Day2 -> Day31 - John Doe didn't make the payment
Day 31 - Trigger of event occurs when the instructor logs in.

Basically on Day 1 when John Doe's profile was created, I want a
decrement counter to occur daily on his profile(some attribute/timer)
and nothing should happen until day 31 when he doesn't pay.

Any ideas?

--
Email: louis(dot)gonzales(at)linuxlouis(dot)net
WebSite: http://www.linuxlouis.net
"Open the pod bay doors HAL!" -2001: A Space Odyssey
"Good morning starshine, the Earth says hello." -Willy Wonka

In response to

  • Postgres-R at 2006-11-02 17:16:24 from Anton P. Linevich

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message A. Kretschmer 2006-11-02 18:26:49 Re: Is there anyway to...
Previous Message Andrew Sullivan 2006-11-02 17:51:16 Re: Postgres-R

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2006-11-02 18:26:49 Re: Is there anyway to...
Previous Message Andrew Sullivan 2006-11-02 17:51:16 Re: Postgres-R

Browse pgsql-sql by date

  From Date Subject
Next Message Hector Villarreal 2006-11-02 18:18:54 Re: hi i am getting error...can u solve this
Previous Message Andrew Sullivan 2006-11-02 17:51:16 Re: Postgres-R