We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Function similar to pg_sleep — Vertica Forum

Function similar to pg_sleep

Navin_CNavin_C Vertica Customer ✭
in General Discussion
Is there any function similar to pg_sleep in Vertia ?

Comments

  • [Deleted User][Deleted User]
    Vertica has the ususal sql "sleep(3)", which takes only integers, unlike pg_sleep which allows float arguments. In vsql you might get slightly more resolution with: \! sleep 3.5 though the shell escape itself takes some amount of time, so there's a bit less accuracy. The shell escape has the advantage of additional forms like \! sleep 2.7 m for 2.7 minutes.
  • [Deleted User][Deleted User]
    Hi Navin, Does 'sleep()' do what you want? https://my.vertica.com/docs/6.1.x/HTML/index.htm#18273.htm Adam

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...