Mathematical functions (ROUND, CEIL, FLOOR, ABS) in PostgreSQL - Step-by-Step Execution

Concept Flow - Mathematical functions (ROUND, CEIL, FLOOR, ABS)

Input Number

↓

Apply Function Logic

↓

Return Result Number

The input number goes through the chosen mathematical function, which processes it and returns the transformed number.

Execution Sample

PostgreSQL

SELECT ROUND(4.7), CEIL(4.2), FLOOR(4.8), ABS(-5);

This query applies ROUND, CEIL, FLOOR, and ABS functions to given numbers and returns their results.

Execution Table

Step	Function	Input	Operation	Result
1	ROUND	4.7	Round to nearest integer	5
2	CEIL	4.2	Round up to next integer	5
3	FLOOR	4.8	Round down to previous integer	4
4	ABS	-5	Absolute value (remove sign)	5
5	END		All functions applied	Query returns (5,5,4,5)

💡 All functions processed inputs and returned their respective results.

Variable Tracker

Variable	Start	After Step 1	After Step 2	After Step 3	After Step 4	Final
ROUND_result	NULL	5	5	5	5	5
CEIL_result	NULL	NULL	5	5	5	5
FLOOR_result	NULL	NULL	NULL	4	4	4
ABS_result	NULL	NULL	NULL	NULL	5	5

Key Moments - 3 Insights

Why does ROUND(4.7) return 5 instead of 4?

ROUND rounds to the nearest integer. Since 4.7 is closer to 5 than 4, it returns 5 as shown in step 1 of the execution_table.

What is the difference between CEIL and FLOOR functions?

CEIL always rounds up to the next integer (step 2), while FLOOR always rounds down to the previous integer (step 3), even if the number is not an integer.

Why does ABS(-5) return 5?

ABS returns the absolute value, which means it removes the negative sign. So ABS(-5) becomes 5 as shown in step 4.

Visual Quiz - 3 Questions

Look at the execution_table, what is the result of FLOOR(4.8) at step 3?

A 4.8

B 4

C 5

D 3

💡 Hint

Check the 'Result' column in row with Step 3 for FLOOR function.

At which step does the ABS function process its input?

A Step 3

B Step 2

C Step 4

D Step 1

💡 Hint

Look for the row where Function is ABS in the execution_table.

If ROUND(4.3) was used instead of ROUND(4.7), what would be the result at step 1?

A 4

B 5

C 3

D 4.3

💡 Hint

ROUND rounds to nearest integer; check how 4.3 compares to 4 and 5.

Concept Snapshot

Mathematical functions in PostgreSQL:
- ROUND(x): rounds x to nearest integer
- CEIL(x): rounds x up to next integer
- FLOOR(x): rounds x down to previous integer
- ABS(x): returns absolute value of x
Use these to transform numbers easily in queries.

Full Transcript

This visual execution trace shows how PostgreSQL mathematical functions ROUND, CEIL, FLOOR, and ABS work step-by-step. The input number is processed by each function: ROUND rounds to the nearest integer, CEIL rounds up, FLOOR rounds down, and ABS returns the positive value. The execution table lists each step with input, operation, and result. Variable tracker shows how results build up. Key moments clarify common confusions like rounding behavior and absolute value. The quiz tests understanding by referencing the execution steps. This helps beginners see exactly how these functions transform numbers in SQL queries.