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