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:
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@postgresql.org so that your message can get through to the mailing list cleanly