From: operationsengineer1@yahoo.com
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: [SQL] [ADMIN] Is there anyway to...
Date: Wed, 8 Nov 2006 17:24:17 -0800 (PST)
Message-ID: <20061109012417.34765.qmail@web33310.mail.mud.yahoo.com> (raw)
In-Reply-To: <20061108061336.GV90133@nasby.net>
> While you could setup a cron job to decrement some
> counter every day, I
> think that's not the best approach. Instead, I'd run
> a query once a day
> that finds all students that are past-due and takes
> some kind of action.
> --
> Jim Nasby
> jim@nasby.net
> EnterpriseDB http://enterprisedb.com
> 512.569.9461 (cell)
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map
> settings
i'm wanting to learn something here so i'm going to
chime in.
the way i read what you are saying is that you'd have
start_date and number_days columns in your table.
each day a query would run and pull the start_date and
numbers_days columns.
the application (or postgresql function) would then
take the current date, subtract starte date and
compare it to number of days. if it is above that
number, the code will take some sort of action.
is that about it or have i missed something?
tia...
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail.
http://new.mail.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: operationsengineer1@yahoo.com, pgsql-general@postgresql.org
Subject: Re: [SQL] [ADMIN] Is there anyway to...
In-Reply-To: <20061109012417.34765.qmail@web33310.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox