Pg-promise: 'select count(*) from foo' will return the count as a string

[Onionz]

I am running the query 'select count(*) from foo' and it return the count as a string type. Is there a way that I can make the count as a number without explicitly casting it using Number().

[vitaly-t]

Is there a way that I can make the count as a number without explicitly casting it using Number().

No.

See also in the demo: https://github.com/vitaly-t/pg-promise-demo/blob/master/JavaScript/db/repos/products.js

    total: () => rep.one("SELECT count(*) FROM Products")
            .then(data => parseInt(data.count))

that's the way to do it.

[Onionz]

I see pg-promise uses node-postgres, is it the implementation of node-postgres or it is just the natural behavior of postgres itself?

[vitaly-t]

I honestly don't know. You can check that yourself. All type conversions are done by pg-types.

[Onionz]

Thanks, I will check it out there. :smiley:

[vitaly-t]

@OnionCoder did you get to the bottom of it?

[Onionz]

When I call count(*) in postgres it returns a 64-bit bigint type number. But Javascirpt does not support 64-bit integers (which is also mentioned in pg-types). So it will be converted to string.

[vitaly-t]

Proper explanation: pg-promise returns integers as strings.

[vitaly-t]

Further development on the subject - BigInt Support.