Not able to cast as decimal

[gagan-bansal]

Here is my example:

const postgres = require('postgres');
const sql = postgres();

(async () => {
  let result = await sql`SELECT 1.5::decimal as score`;
  console.log(typeof result[0].score);
  result = await sql`SELECT 1.5 as score`;
  console.log(typeof result[0].score);
})();

For both output is string. Am I doing something wrong?

[porsager]

Decimal can't be represented in js Number without loosing precision, so it would be irresponsible to cast implicitly. Instead you can eg. cast to ::float in sql

[gagan-bansal]

Thank you @porsager, that was quite helpful.