Re: Sleep functions

Michael Fuhr wrote:

>What do people think of exposing pg_usleep() to the user?  It's
>sometimes useful to have a server-side sleep function, and people
>do ask about it occasionally (e.g., Don Drake today in pgsql-admin).
>It's easy enough to do in PL/Perl, PL/Tcl, etc., but since the
>backend already has pg_usleep(), is there any reason not to expose
>it?  I'd propose both sleep() and usleep() functions.
>  
>


Be careful with documentation - IIRC on Windows the granularity of the 
Sleep() function is 1 millisec and pg_usleep rounds to the nearest 
millisec except for very low values where it rounds up.

cheers

andrew