X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.192])
	by svr1.postgresql.org (Postfix) with ESMTP id 49089D1C4E1
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 22 Jul 2003 08:09:05 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new,
	port 10024) with ESMTP id 44819-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 22 Jul 2003 08:09:03 +0000 (GMT)
Received: from hermes.tietronix.com (hermes.tietronix.com [216.138.125.222])
	by svr1.postgresql.org (Postfix) with ESMTP id 7E2BBD1C4DC
	for <pgsql-sql@postgresql.org>; Tue, 22 Jul 2003 05:09:02 -0300 (ADT)
Date: Tue, 22 Jul 2003 02:59:31 -0500
Message-Id: <200307220259.AA56950830@hermes.tietronix.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
From: "Girish Bajaj" <gbajaj@tietronix.com>
Reply-To: <gbajaj@tietronix.com>
X-Sender: <gbajaj@tietronix.com>
To: <pgsql-sql@postgresql.org>
Subject: time delay function
X-Mailer: <IMail v8.00>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0 tests=BAYES_30,
	RCVD_IN_NJABL, X_NJABL_OPEN_PROXY
X-Spam-Level: 
X-Archive-Number: 200307/317
X-Sequence-Number: 14431

Pseudo code:

begin trans
select * from table1
WAIT FOR 20 SECS
update table1 set blah = 'blah'
end transcation

In pgplsql, Im looking for something like a function that I can use to make the process to wait for 20 secs before continuing to execute the next sql statment? 

Thanks,
Girish