On Sun, Aug 21, 2005 at 02:22:25PM -0500, Don Drake wrote:
> Is there a sleep function in plpgsql? I need to wait a period time (60
> seconds) in a while loop.
SELECT oid::regprocedure
FROM pg_proc
WHERE proname ILIKE '%sleep%' OR prosrc ILIKE '%sleep%';
oid
-----
(0 rows)
When I need a sleep function on the server side I write one in C,
PL/Perl, PL/Tcl, PL/Python, etc. PostgreSQL 8.0 and later have an
internal pg_usleep() function but it's not exposed to the user. I
asked about exposing it recently but didn't see any replies (it was
in response to a message in pgsql-committers; I suppose I should
have asked in pgsql-hackers instead).
--
Michael Fuhr