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 66C07D77C8 for ; Sun, 21 Aug 2005 20:17:06 -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 84567-04 for ; Sun, 21 Aug 2005 23:16:57 +0000 (GMT) Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 8224DD76BC for ; Sun, 21 Aug 2005 20:16:33 -0300 (ADT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr2.postgresql.org (Postfix) with SMTP id 3F675F0D92 for ; Sun, 21 Aug 2005 20:58:42 +0100 (BST) Received: (qmail 10460 invoked from network); 21 Aug 2005 20:03:03 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 21 Aug 2005 20:03:03 -0000 From: "Greg Sabino Mullane" To: pgsql-admin@postgresql.org Subject: Re: sleep? X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <6c21003b050821122278e3d7d5@mail.gmail.com> Date: Sun, 21 Aug 2005 20:03:03 -0000 X-Mailer: JoyMail 1.48 Message-ID: <0817d53432c7b8dc53a6cc9c014261e9@biglumber.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.208 required=5 tests=[AWL=0.001, UPPERCASE_25_50=0.207] X-Spam-Level: X-Archive-Number: 200508/255 X-Sequence-Number: 18574 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > Is there a sleep function in plpgsql? I need to wait a period time > 60 seconds) in a while loop. You will need to us another language, such as plperl. You could certainly create a sleep function and have your plpgsql call that: CREATE FUNCTION sleep(INT) RETURNS TEXT LANGUAGE plperl AS $$ select(undef,undef,undef,shift); return "Time to wake up!"; $$; SELECT sleep(2); - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200508211601 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFDCN3BvJuQZxSWSsgRAhtJAKD0QDRWb6kk+AGWHMPQqM7lwRAXKACgpHM0 EkA+7aOQoI3BzgLhkva53mQ= =hD9m -----END PGP SIGNATURE-----