Hi, > I don't think this is really possible with postgres PLs generally. > Typically what you have to do is have a function that is called on an > interval that checks for alarms and runs them.
Thanks for the prompt reply. Just to clarify: you are saying that the function that is called with a given periodicity must be so from *outside* PG, ie, from the client application, right? I mean, there is no way strictly internal to PG to have a function be called every given number of seconds? Cheers, Jon -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general