On 3/29/2013 10:54 AM, Yuriy Rusinov wrote:
> I have to write pl/pgsql function that has to be triggered not
> before/after insert, but in definite time. Does postgresql allows to
> do this ?
there is no 'cron' built into postgresql. you could write your
function, then have an external cron job invoke it, like: psql -c
"select yourfunction()"
--
john r pierce 37N 122W
somewhere on the middle of the left coast