time based/trigger events in postgre sql

[Naug]

Im trying to make a game using php and postgre, and I need few things to happen:

1) for db to do specified operation like deleting all unneeded records after some time (or immideatley) from certain conditions being meat.
2) for db to do some action at regular intervals ,like bank adding interest for example.

[Pig]

Write a script for the actions you want performed, and have them activated with CRON.

[Naug]

in which language that would be? Could you recomend some basic tutorial? I studied java so not to sure (no at all sure) in C/Perl scripting

[Pig]

For the update, just use PHP. For instance, if you want to delete all of the records that are older than 1 month and have an inactive flag, you file would look like this:

<?php
$result = mysql_query("DELETE FROM table_name WHERE create_date < '" . strtotime("now -30 days") . "' AND active='2'");
?>

For information on cron, check google.
http://www.google.com/search?sourceid=navclient&ie=UTF-8&oe=UTF-8&q=cron

[Sxooter]

I too write all my system admin scripts in PHP nowadays. Just make the first line of the file:

#!/usr/local/bin/php -q

or whatever the path is to the php executable, and chmod the file to 755 so it's executable and dump it into /etc/cron.daily (or hourly, weekly, or monthly) and you're gold.

[Pig]

Yes, and just in case it isn't obvioius, do NOT put the file anywhere in your htdocs folder.