On Tue, 2003-07-22 at 04:22, Christoph Haller wrote:
> >
> > 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 wa
Girish Bajaj writes:
> 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?
There is no built-in support for that, but you could write your own
function in C that accomplishes that, for
>
> 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 con
tinuing to execute the next sql statment?
>
AFAIK
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
-