Re: sleep? - Mailing list pgsql-admin

From Bricklen Anderson
Subject Re: sleep?
Date
Msg-id 4308E366.5020608@presinet.com
Whole thread Raw
In response to sleep?  (Don Drake <dondrake@gmail.com>)
List pgsql-admin
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)

pgsql-admin by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: sleep?
Next
From: John DeSoi
Date:
Subject: Re: sleep?