How to use ILIKE?

[isgj]

Hey, what could be a function to use ILIKE in postgres? Or is it possible to extend the StringExpression interface for postgres?

[go-jet]

Currently, ILIKE is not supported. You'll have to use Raw method. For instance:

BoolExp(Raw("table.column ILIKE :value", , RawArgs{":float": "_val%" }))

, or you can simulate ILIKE using LOWER:

LOWER(table.column).LIKE(String("_val%"))

Not sure about extending StringExpression because ILIKE is postgres specific, and StringExpression is interface for all dialects. Probably new ILIKE method would be the best: ILIKE(table.column, String("_val%")).

[isgj]

Thanks, yeah currently I'm using LOWER.

Maybe StringExpression can be extended when re-exported from jet/postgres module but this will require a lot of updates.
I like the idea of the ILIKE function func ILIKE(StringExpression, StringExpression) BoolExpression as it can use github.com/go-jet/jet/v2/internal/jet.

Or https://github.com/go-jet/jet/blob/master/internal/jet/expression.go#L99 can be reexported so it will be easier to create db specific operators.

[go-jet]

Maybe StringExpression can be extended when re-exported from jet/postgres module but this will require a lot of updates.

Yeah, it should be possible, but as you said it would require a lot of changes. It is probably not worth it, for just one operator.

Or https://github.com/go-jet/jet/blob/master/internal/jet/expression.go#L99 can be reexported so it will be easier to create db specific operators.

Yeah, it makes sense to export it for postgres dialect, because postgres allows creation of new custom operators. Although, not sure if this postgres feature is used at all.