Is there any way to create a literal `Op<Boolean>` ? My issue is that I want to do `Time(MyTable.tim...

# exposed

[Alexander]

Is there any way to create a literal Op<Boolean> ? My issue is that I want to do Time(MyTable.timestamp).between(startTime, endTime), but the TIME expression isn't available in Postgres. The way to do it in postgres would be with table_name.timestamp::time BETWEEN startTime AND endTime

So I would like to do something like:

MyTable.select(MyTable.columns)
  .where { literalExpression("my_table.timestamp::time between $startTime AND $endTime") }

[Alexander]

Solved it by creating a modified Time class instead:

public class TimePg<T : Temporal?>(
	public val expr: Expression<T>,
) : Function<LocalTime>(ExposedStatic.LOCAL_TIME_COLUMN) {
	override fun toQueryBuilder(
		queryBuilder: QueryBuilder,
	): Unit = queryBuilder { append(expr, "::time") }
}

[spand]

Does something like this work:

MyTable.timestamp.castTo<LocalTime>(JavaLocalTimeColumnType()).between(...)

[spand]

ie. casting instead of using ::time

[Alexander]

That seems to do the trick as well, thanks