PostgreSQL – How to Generate a Random Number within a Range

ByAdmin

You can use the RANDOM() function to generate a random floating-point number between 0 and 1 in PostgreSQL database. Here’s the basic syntax for using the RANDOM() function:

SELECT RANDOM();

This will return a random number in the range [0, 1), meaning it can be any decimal value between 0 (inclusive) and 1 (exclusive).

If you want to generate random integers within a specific range, you can use the following formula:

SELECT floor(random() * (max - min + 1) + min);

Here

  • random() generates a random floating-point number in the range [0, 1).
  • (max - min + 1) represents the range of integers you want.
  • floor() is used to round down the floating-point number to the nearest integer.
  • min is the lower bound of the range, and max is the upper bound.

For example, if you want to generate a random integer between 1 and 100 (inclusive), you can use the following SQL query:

SELECT floor(random() * (100 - 1 + 1) + 1);

This will give you a random integer between 1 and 100.

Similar Posts

PostgreSQL – How to List all Tables

ByAdmin

To list all the tables in a PostgreSQL database, you can query the information_schema database which contains metadata about all the tables and other objects in the database. Below is the SQL query you can use to show all the tables: SELECT table_name FROM information_schema.tables WHERE table_schema = ‘public’; This query will retrieve the names…

PostgreSQL – How to Modify log_rotation_size Parameter

ByAdmin

The log_rotation_size parameter determines the size at which PostgreSQL’s log files (usually the log file generated by the pg_log system) will be rotated or switched to a new file. Rotating log files helps postgresql database engine to manage the log file size and prevent them from growing too large, which can be particularly useful for…