Node.js: PostgreSQL's SUM() returns a string instead of an integer

Question

In MySQL, it's because SUM() returns a DECIMAL. From PostgreSQL docs:

sum(smallint) → bigint  
sum(integer) → bigint  
sum(bigint) → numeric  
sum(numeric) → numeric  
sum(real) → real  
sum(double precision) → double precision  
sum(interval) → interval  
sum(money) → money
     Computes the sum of the non-null input values.

Since I'm calculating the sum of integers, therefore it should return an integer?

M Imam Pratama · Accepted Answer · 2022-10-28 06:37:25Z

4

Postgres' bigint is up to 2⁶⁴ which is larger than JavaScript's Number.MAX_SAFE_INTEGER (2⁵³), therefore it's usually represented with string.

We can use JS' parseInt() or cast bigint to integer directly:

SELECT CAST(SUM(salary) as INTEGER)
FROM employee;

answered Oct 28, 2022 at 6:37

M Imam Pratama

1,4071 gold badge15 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Node.js: PostgreSQL's SUM() returns a string instead of an integer

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related