Re: SLEEP in posgresql

I think pg_sleep is not implemented in 8.1 and earlier versions. Is there
any alternative if someone is using versions before 8.2 ?

On 10/9/07, Guy Rouillier <guyr-ml1(at)burntmail(dot)com> wrote:
>
> Jasbinder Singh Bali wrote:
> > Hi,
> >
> > I have a while loop and I want to re-iterate after every 't' seconds.
> > I was reading up on the postgresql documentation that says pg_sleep(t)
> > should be handy.
> > However i doesn't work.
>
> Hmmm, I'm looking at section 9.9.5 Delaying Execution in the PostgreSQL
> 8.2.0 Documentation. Following the example presented there, I fired up
> psql and ran the following:
>
> postgres=# select current_timestamp; select pg_sleep(3); select
> current_timestamp;
> now
> ----------------------------
> 2007-10-09 23:50:32.649-04
> (1 row)
>
> pg_sleep
> ----------
>
> (1 row)
>
> now
> ----------------------------
> 2007-10-09 23:50:35.774-04
> (1 row)
>
> Seems to be working. What version are you using and on what platform?
>
> --
> Guy Rouillier
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>