OverHash
OverHash
PostsComments
KKysely
Created by OverHash on 3/6/2025 in #help
AggregateFunctionBuilder inside a SUM
Thanks for explaining!
8 replies
KKysely
Created by OverHash on 3/6/2025 in #help
AggregateFunctionBuilder inside a SUM
Ahh nice, awesome!
8 replies
KKysely
Created by OverHash on 3/6/2025 in #help
sql literal string in binary expression builder
thx!
9 replies
KKysely
Created by OverHash on 3/6/2025 in #help
sql literal string in binary expression builder
oh yup, you are right haha 😅
9 replies
KKysely
Created by OverHash on 3/6/2025 in #help
sql literal string in binary expression builder
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">'.
9 replies
KKysely
Created by OverHash on 10/15/2024 in #help
ilike with reference
Using 
sql`'%'`,
sql`'%'`,
Seemed to do the trick, instead of eb.val("%"). Any other ways to make this more ergonomic?
6 replies
KKysely
Created by OverHash on 10/15/2024 in #help
ilike with reference
I guess I need a way to embed % directly into my query?
6 replies
KKysely
Created by OverHash on 10/15/2024 in #help
ilike with reference
Oh actually I think this is Postgres itself throwing the error? Not pg.
6 replies
KKysely
Created by OverHash on 10/5/2024 in #help
Casting part of a return type
ok, thanks for your help and tips. think its good to close this now!
38 replies
KKysely
Created by OverHash on 10/5/2024 in #help
Casting part of a return type
key being the <number> as the sum, rather than <string>
38 replies
KKysely
Created by OverHash on 10/5/2024 in #help
Casting part of a return type
aha I found my issue, I was using a CTE and 
.with("total_quantity", (db) =>
  db
    .selectFrom("person")
    .select((eb) =>
      eb.fn
        .sum<number>("person.initial_quantity")
        .as("quantity_consumed"),
    )
)
.with("total_quantity", (db) =>
  db
    .selectFrom("person")
    .select((eb) =>
      eb.fn
        .sum<number>("person.initial_quantity")
        .as("quantity_consumed"),
    )
)
38 replies
KKysely
Created by OverHash on 10/5/2024 in #help
Casting part of a return type
but i can't see that being possible
38 replies