X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 53482D6DA8 for ; Sun, 21 Aug 2005 20:33:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91160-01 for ; Sun, 21 Aug 2005 23:33:47 +0000 (GMT) Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 7FA59D76AD for ; Sun, 21 Aug 2005 20:33:15 -0300 (ADT) Received: from presinet.com (presinet.com [209.53.156.1]) by svr2.postgresql.org (Postfix) with ESMTP id 2F486F1206 for ; Sun, 21 Aug 2005 21:22:16 +0100 (BST) Received: from [10.10.1.204] ([10.10.1.204]) by presinet.com with Microsoft SMTPSVC(6.0.3790.211); Sun, 21 Aug 2005 13:25:32 -0700 Message-ID: <4308E366.5020608@presinet.com> Date: Sun, 21 Aug 2005 13:26:14 -0700 From: Bricklen Anderson User-Agent: Debian Thunderbird 1.0.2 (X11/20050602) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Don Drake Cc: pgsql-admin@postgresql.org Subject: Re: sleep? References: <6c21003b050821122278e3d7d5@mail.gmail.com> In-Reply-To: <6c21003b050821122278e3d7d5@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 21 Aug 2005 20:25:32.0343 (UTC) FILETIME=[7AA99C70:01C5A68E] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.011 required=5 tests=[AWL=0.011] X-Spam-Level: X-Archive-Number: 200508/256 X-Sequence-Number: 18575 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)