Re: [SQL] sleep function

[John DeSoi]

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;
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend