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
