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 B3777D6D84 for ; Sun, 21 Aug 2005 18:09:51 -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 38343-06 for ; Sun, 21 Aug 2005 21:09:48 +0000 (GMT) Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.194]) by svr1.postgresql.org (Postfix) with ESMTP id 47356D6D80 for ; Sun, 21 Aug 2005 18:09:47 -0300 (ADT) Received: by nproxy.gmail.com with SMTP id c2so155392nfe for ; Sun, 21 Aug 2005 14:09:49 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=L8Uu7C9CQXhVNvLk0Mwx+INZmXdb97HBI+/VJT7kMdK0diDFcPh5kzPQ4d7VAsegGG0ueBTiiBHLpYOpLu0x7n8ezCncLNbcp29R/QZrWJXl0abbHnGHLTPR5fitvY9sRwvkkEKp2DaIlfAqTPr5W1jV0q2mgIsI82GAFjyFfd8= Received: by 10.48.161.20 with SMTP id j20mr110252nfe; Sun, 21 Aug 2005 14:09:49 -0700 (PDT) Received: by 10.48.144.16 with HTTP; Sun, 21 Aug 2005 14:09:49 -0700 (PDT) Message-ID: Date: Sun, 21 Aug 2005 22:09:49 +0100 From: Guido Barosio To: Don Drake Subject: Re: sleep? Cc: pgsql-admin@postgresql.org In-Reply-To: <6c21003b050821122278e3d7d5@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7753_32090963.1124658589081" References: <6c21003b050821122278e3d7d5@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.183 required=5 tests=[AWL=0.063, HTML_50_60=0.095, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200508/253 X-Sequence-Number: 18572 ------=_Part_7753_32090963.1124658589081 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Don't know about such thing, but I guess that a plpgsql function could help= =20 using datetime var's. Just a guess, don't know if the optimal solution. Best wishes, G.- On 8/21/05, Don Drake wrote:=20 >=20 > Is there a sleep function in plpgsql? I need to wait a period time (60=20 > seconds) in a while loop. >=20 > I didn't see anything in the docs. >=20 > Thanks. >=20 > -Don >=20 > --=20 > Donald Drake > President > Drake Consulting > http://www.drakeconsult.com/ > http://www.MailLaunder.com/ > http://www.mobilemeridian.com/ > 312-560-1574 >=20 >=20 --=20 "Adopting the position that you are smarter than an automatic optimization algorithm is generally a good way to achieve less performance, not more" - Tom Lane. ------=_Part_7753_32090963.1124658589081 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Don't know about such thing, but I guess that a plpgsql function could= help using datetime var's.
 
Just a guess, don't know if the optimal solution.
 
Best wishes,
G.-

 



--
"Adopting the position that = you are smarter than an automatic
optimization algorithm is generally a = good way to achieve less
performance, not more" - Tom Lane.=20 ------=_Part_7753_32090963.1124658589081--