Kysely•2mo ago

sql literal string in binary expression builder

Hi, I want the following:

SELECT
  sum("ChargeAmount" * "1.0") AS "TotalChargeAmount"
FROM
  "person"

SELECT
  sum("ChargeAmount" * "1.0") AS "TotalChargeAmount"
FROM
  "person"

but I can't get the literal "1.0" in there, I can only get 1.0 -- because the binary expression builder won't accept string inputs. I have tried using sql.lit and sql.raw, but both don't work (for getting just the "1.0"). repro link: https://kyse.link/9jBtv Does anyone know how I could get there?

Solution:

You definitely don't want "1.0" since that means you're referencing a column named 1.0

Jump to solution

4 Replies

OverHashOP•2mo ago

Attempting to use sql.lit("1.0") will produce

Argument of type 'RawBuilder<string>' is not assignable to parameter of type 'OperandValueExpressionOrList<Database, "person", "ChargeAmount">'.

Argument of type 'RawBuilder<string>' is not assignable to parameter of type 'OperandValueExpressionOrList<Database, "person", "ChargeAmount">'.

koskimas•2mo ago

sql.lit(1.0) or eb.lit(1.0) https://kyse.link/MY40g

Solution

koskimas•2mo ago

You definitely don't want "1.0" since that means you're referencing a column named 1.0

OverHashOP•2mo ago

oh yup, you are right haha 😅 thx!

Gaming

Programming

sql literal string in binary expression builder

Did you find this page helpful?