Kysely•12mo ago•

8 replies

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"

"1.0"

in there, I can only get

1.0

1.0

-- because the binary expression builder won't accept string inputs. I have tried using

sql.lit

sql.lit

and

sql.raw

sql.raw

, but both don't work (for getting just the

"1.0"

"1.0"

).

repro link: https://kyse.link/9jBtv

Does anyone know how I could get there?

Solution

You definitely don't want

"1.0"

"1.0"

since that means you're referencing a column named

1.0

1.0