Raw SQL in select type to number

Hellow, I have the following sql expression in a select statement array:

 sql<number>`(${sql.raw(precisionScore)} * 100)::NUMERIC(10,2)`

 sql<number>`(${sql.raw(precisionScore)} * 100)::NUMERIC(10,2)`

but the return type of the column in the row is a string. How can I get the type to be a number?

Solution

The

pg

pg

driver returns numeric type as a string. Use the

pg-types

pg-types

package to configure the type.