Re: sleep function

On Aug 10, 2004, at 10:57 AM, Bruce Momjian wrote:

> I can't think of one, no.  I think you will have to use one of the
> server-side languages and call a sleep in there.


This is no good in the real world since it pounds the CPU, but it 
worked well enough for my testing purposes.

Best,

John DeSoi, Ph.D.




create or replace function sleep (integer) returns time as 'declare	seconds alias for $1;	later time;	thetime time;begin	thetime := timeofday()::timestamp;	later := thetime + (seconds::text || '' seconds'')::interval;	loop		if thetime >= later then			exit;		else			thetime := timeofday()::timestamp;		end if;	end loop;
	return later;end;
' language plpgsql;