Postgres sequelize raw query to get count returns string value

Question

I am using postgresql sequelize in my node-express server.

When I run the following SQL Command, I am getting a string value for result.

I want to get Integer value for this count.

SELECT count(id) from collaborators where id<3

Result:

count =  [ { count: '1' } ]

Is there any way to get number values for result? Or do I always need to use parseInt(count, 10) to get int value?

I appreciate any help!

Miko Chu · Accepted Answer · 2021-04-12 13:04:39Z

15

@DemtriOS is correct that count returns bigint hence interpreted into string, you can directly typecast it directly on your query like so:

SELECT COUNT(id)::int
FROM collaborators
WHERE id < 3

answered Apr 12, 2021 at 13:04

Miko Chu

1,42819 silver badges27 bronze badges

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

Comments

DemetriOS · Accepted Answer · 2017-12-16 07:36:47Z

4

According to this https://www.postgresql.org/docs/8.2/static/functions-aggregate.html, the count() function returns bigint type. Because of this it will get interpreted as a string. It looks like explicit conversion to an int is what you will have to do. So, parseInt(count, 10) it is.

answered Dec 16, 2017 at 7:36

DemetriOS

19113 bronze badges

1 Comment

bbsimonbb Over a year ago

Yuck. I don't like that at all.

Collectives™ on Stack Overflow

Postgres sequelize raw query to get count returns string value

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related