Gustav Elmgren
02/08/2022, 4:24 PMnullif
function). But I have no idea what to specify the column type as. Any thoughts?Bogdan
02/08/2022, 7:54 PMGustav Elmgren
02/09/2022, 4:57 PMnullif
does not have one I guess?Bogdan
02/10/2022, 3:41 PMclass NullIf<T>(expr: ExpressionWithColumnType<T>, default: Expression<T>) :
CustomFunction<T>("nullif", expr.columnType, expr, default)
class NullIf<T>(expr: Expression<T>, default: Expression<T>, columnType: IColumnType) :
CustomFunction<T>("nullif", columnType, expr, default)
fun <T> nullif(expr: ExpressionWithColumnType<T>, default: Expression<T>): NullIf<T> =
NullIf(expr, default, expr.columnType)
fun <T> nullif(expr: Expression<T>, default: ExpressionWithColumnType<T>): NullIf<T> =
NullIf(expr, default, default.columnType)
// optimistic: VarCharColumnType
fun <T> nullif(expr: Expression<T>, default: Expression<T>): NullIf<T> =
NullIf(expr, default, VarCharColumnType())
fun <T> nullif(expr: ExpressionWithColumnType<T>, default: T): NullIf<T> =
NullIf(expr, QueryParameter(default, expr.columnType), expr.columnType)
Gustav Elmgren
02/10/2022, 3:57 PMBogdan
02/10/2022, 4:38 PMfun <T> nullif(expr: ExpressionWithColumnType<T>, default: T): NullIf<T?> =
Gustav Elmgren
02/11/2022, 11:11 AM