PostgreSQL DIV() Function
PostgreSQL DIV() Function
The PostgreSQL DIV() function is used to perform integer division. This function is essential for dividing one number by another and returning the integer part of the quotient, discarding any fractional part.
Syntax
number1 / number2
The DIV() function has the following components:
number1: The dividend.number2: The divisor.
Example PostgreSQL DIV() Queries
Let's look at some examples of PostgreSQL DIV() function queries:
1. Basic DIV() Example
SELECT 10 / 3 AS result;
This query returns the result of the integer division of 10 by 3, which is 3.
2. DIV() with Column Values
SELECT dividend, divisor, dividend / divisor AS result
FROM division_data;
This query retrieves the dividend, divisor, and the result of their integer division from the division_data table.
3. DIV() with Negative Values
SELECT dividend, divisor, dividend / divisor AS result
FROM division_data
WHERE dividend < 0;
This query retrieves the dividend, divisor, and the result of their integer division from the division_data table where the dividend is negative.
Full Example
Let's go through a complete example that includes creating a table, inserting data, and using the DIV() function to perform integer division.
Step 1: Creating a Table
This step involves creating a new table named division_data to store numerical data for division.
CREATE TABLE division_data (
id SERIAL PRIMARY KEY,
dividend NUMERIC,
divisor NUMERIC
);
In this example, we create a table named division_data with columns for id, dividend, and divisor.
Step 2: Inserting Data into the Table
This step involves inserting some sample data into the division_data table.
INSERT INTO division_data (dividend, divisor)
VALUES (10, 3),
(20, 4),
(-30, 5),
(40, 6);
Here, we insert data into the division_data table.
Step 3: Using the DIV() Function
This step involves using the DIV() function to perform integer division on the data in the division_data table.
Basic DIV()
SELECT dividend, divisor, dividend / divisor AS result
FROM division_data;
This query performs division on each pair of values in the 'dividend' and 'divisor' columns of the 'division_data' table.
DIV() with Negative Values
SELECT dividend, divisor, dividend / divisor AS result
FROM division_data
WHERE dividend < 0;
This query performs division on each pair of values in the 'dividend' and 'divisor' columns of the 'division_data' table where the 'dividend' is less than 0.
These queries demonstrate how to use the DIV() function to perform integer division on the data in the division_data table, including basic usage and handling negative values.
Conclusion
The PostgreSQL DIV() function is a fundamental tool for performing integer division and obtaining the integer part of the quotient. Understanding how to use the DIV() function and its syntax is essential for effective data retrieval and manipulation in PostgreSQL databases.