In PostgreSQL, the abs() function returns the absolute value of its argument.
The absolute value means how far the number is away from zero. Therefore, the absolute value of 7 is 7, and the absolute value of -7 is also 7.
Therefore, any negative values passed to abs() are returned as positive values. Positive values and zero are returned unchanged.
In SQL Server, you can use the WAITFOR statement to delay the execution of a batch, stored procedure, or transaction.
It works similar to MySQL‘s sleep() function.
Actually, it’s probably more like a combination of Postgres‘s three “sleep” functions: pg_sleep(), pg_sleep_for(), and pg_sleep_until().
I say this, because SQL Server’s WAITFOR statement gives you the option of specifying either a time delay, or an actual fixed time before execution continues.
In PostgreSQL, you can use the pg_sleep() function to delay execution for a given number of seconds.
It makes the current session’s process sleep until the specified number of seconds have elapsed. It works similar to MySQL‘s sleep() function, and also TSQL‘s waitfor statement in SQL Server.
The pg_sleep() function accepts a double precision argument, so you can also specify fractional-second delays.
The sleep delay will be at least as long as specified. However, it could be longer depending on factors such as server load, as well as your platform’s effective resolution of the sleep interval.
Continue readingIn PostgreSQL, you can use the pg_sleep_for() function to delay execution for a given interval.
It makes the current session’s process sleep until the specified interval has elapsed.
The sleep delay will be at least as long as specified. However, it could be longer depending on factors such as server load, as well as your platform’s effective resolution of the sleep interval.
Continue readingIn PostgreSQL, you can use the pg_sleep_until() function to delay execution until a specified timestamp.
This is useful for when a specific wake-up time is desired.
Note that pg_sleep_until is not guaranteed to wake up exactly at the specified time, but it will not wake up any earlier.
In PostgreSQL, the setseed() function sets the seed for subsequent random() and random_normal() calls (value between -1.0 and 1.0, inclusive).
The random() function generates a pseudo-random number using a simple linear congruential algorithm. The random_normal() function generates a normally-distributed random number.
If setseed() is called, the results of subsequent random() and random_normal() calls in the current session are repeatable by re-issuing setseed() with the same argument.
In PostgreSQL, the random() function returns a pseudo-random value in the range 0.0 <= x < 1.0.
It uses a simple linear congruential algorithm, which is one of the oldest and best-known pseudo-random number generator algorithms.
A pseudo-random number is a number that appears to be random, but is not truely random. A pseudo-random number is not truely random because its value was generated by a known seed. However, it will appear to be random if the user has no knowledge of the seed or algorithm that created it.
Therefore, pseudo-random numbers are often considered good enough for many applications.
Continue readingIn PostgreSQL, cot() is a trigonometric function that returns the cotangent of the specified angle.
The angle is provided as an argument, specified in radians.
In trigonometry, in a right triangle, the cotangent of an angle is the length of the adjacent side divided by the length of the opposite side.
Continue readingIn PostgreSQL, cotd() is a trigonometric function that returns the cotangent of the specified angle.
The angle is provided as an argument, specified in degrees.
In trigonometry, in a right triangle, the cotangent of an angle is the length of the adjacent side divided by the length of the opposite side.
Continue readingIn PostgreSQL, atan2() is a trigonometric function that returns the arctangent, or inverse tangent, of the specified x and y coordinates in radians.