PostgreSQL Tutorial PostgreSQL Advanced PostgreSQL Database Account Management PostgreSQL References
PostgreSQL Tutorial PostgreSQL Advanced PostgreSQL Database Account Management PostgreSQL References

PostgreSQL SCALE() Function

The PostgreSQL SCALE() function returns the scale of the argument (the number of decimal digits in the fractional part).

Syntax

SCALE(number)

Parameters

number Required. Specify the number.

Return Value

Returns the scale of the argument.

Example 1:

The example below shows the usage of SCALE() function.

SELECT SCALE(0.12345);
Result: 5

SELECT SCALE(1.2345);
Result: 4

SELECT SCALE(12.345);
Result: 3

SELECT SCALE(123.45);
Result: 2

SELECT SCALE(1234.5);
Result: 1

SELECT SCALE(12345);
Result: 0

SELECT SCALE('123.45');
Result: 2

Example 2:

Consider a database table called Sample with the following records:

Datax
Data 11.56
Data 21.7
Data 31.89
Data 41.634
Data 51.678

The statement given below can be used to calculate the scale of column x values.

SELECT *, SCALE(x) AS SCALE_Value FROM Sample;

This will produce the result as shown below:

DataxSCALE_Value
Data 11.562
Data 21.71
Data 31.892
Data 41.6343
Data 51.6783

❮ PostgreSQL Functions
AlphaCodingSkills
AlphaCodingSkills Android App
Facebook Page Twitter Page LinkedIn Page
Learning Tutorials
Learning Tutorials
Useful Links
Python Libraries
About Us  |  Privacy Policy  |  Contact Us
AlphaCodingSkills is a online learning portal that provides tutorials on Python, Java, C++, C, C#, PHP, R, Ruby, Rust, Scala, Swift, Perl, SQL, Data Structures and Algorithms. Tutorials, examples, references and content of the website are reviewed and simplified continuously to improve comprehensibility and eliminate any possible error. We use cookies to ensure best browsing experience on our website. While using this website, you acknowledge to have read and accepted our cookie and privacy policy.