Skip site navigation (1) Skip section navigation (2)

Re: sleep?

From: Bricklen Anderson <banderson(at)presinet(dot)com>
To: Don Drake <dondrake(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: sleep?
Date: 2005-08-21 20:26:14
Message-ID: 4308E366.5020608@presinet.com (view raw or flat)
Thread:
Lists: 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)

In response to

  • sleep? at 2005-08-21 19:22:25 from Don Drake

pgsql-admin by date

Next:From: Guido BarosioDate: 2005-08-21 21:09:49
Subject: Re: sleep?
Previous:From: Greg Sabino MullaneDate: 2005-08-21 20:03:03
Subject: Re: sleep?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group