Re: sleep?

[Bricklen Anderson <banderson@xxxxxxxxxxxx>]

Don Drake 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

create or replace function sleep(integer) returns void as $$
return sleep(shift)
$$ language plperlu immutable strict;

select sleep(5);
--(sleeps for 5 seconds)