Don't know about such thing, but I guess that a plpgsql function could help using datetime var's.
Just a guess, don't know if the optimal solution.
Best wishes,
G.-
On 8/21/05, Don Drake <dondrake@xxxxxxxxx> wrote:
Is there a sleep function in plpgsql? I need to wait a period time (60 seconds) in a while loop.
I didn't see anything in the docs.
Thanks.
-Don
--
Donald Drake
President
Drake Consulting
http://www.drakeconsult.com/
http://www.MailLaunder.com/
http://www.mobilemeridian.com/
312-560-1574
--
"Adopting the position that you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
performance, not more" - Tom Lane.