Re: SLEEP in posgresql

I'm using Postgresql Version 8.1.4. on fedora core 6
I'm pretty sure that pg_sleep is not implemented in 8.1.
Am not sure what is the work around

Jas

On 10/10/07, Harpreet Dhaliwal <harpreet(dot)dhaliwal01(at)gmail(dot)com> wrote:
>
> 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
> >
>
>