Kysely•3y ago

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)`

 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

pg

pg driver returns numeric type as a string. Use the

pg-types

pg-types

pg-types

pg-types package to configure the type.

Jump to solution

bombillazoOP•11/1/23, 6:00 PM

Im using an expression that is repeatedly used across my query

bombillazoOP•11/1/23, 6:06 PM

Im still getting the data backa s string

bombillazoOP•11/1/23, 6:09 PM

postgres

bombillazoOP•11/1/23, 6:09 PM

0.26.3

bombillazoOP•11/1/23, 6:09 PM

.select([
      'sub.id',
      sql`(${sql.raw(precisionScore)} * 100)::NUMERIC(10,2)`.as(
        'precision_score',
      ),
    ]);

.select([
      'sub.id',
      sql`(${sql.raw(precisionScore)} * 100)::NUMERIC(10,2)`.as(
        'precision_score',
      ),
    ]);

bombillazoOP•11/1/23, 6:10 PM

I just want kysely to return that column as a number

bombillazoOP•11/1/23, 6:10 PM

Im not sure if raw queries will simply be always returned as string

bombillazoOP•11/1/23, 6:12 PM

I tried:

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

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

and both return as string

Solution