select count(*) as c from users returns type "string" about node-pg-types

[bendrucker]

This is not a bug. Take a look at the postgres docs on the types of the aggregate functions:

http://www.postgresql.org/docs/9.4/static/functions-aggregate.html

You'll see that count is a bigint. node-postgres can't auto-parse that for you without loss of precision. If you know that your counts are small enough, you can safely parse it in your application code.

[bf]

This issue appeared overnight and created failing comparisons like count === 2 which now needs to be either SQL-typecasted or parseInt(count, 10) === 2. I know about bigint conversion problems but in my case this issue arose in a mature project without me changing much before.

Now I am stuck trying to figure out if a postgres update caused this behavior, or some hidden node-pg update, or.. ?

[bendrucker]

No idea what changed in your setup but this has been the behavior in node-postgres for a long time, well over a year if memory serves.

[bf]

Okay, thanks for the clarification. This lets me rule out a change in the node-pg modules. I still cannot wrap my head around this issue.