[SQL] time delay function

[Girish Bajaj]

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



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings