Hi all! any suggestion how to run this kind of que...

# exposed

[alon shoshani.86]

Hi all!
any suggestion how to run this kind of query in postgresql with expose?

UPDATE events_affecting_transit 
SET estimated_affect_end_time = estimated_affect_end_time + interval '5 hour'
WHERE current_timestamp > estimated_affect_end_time

[alon shoshani.86]

when I'm trying do like that,

[alon shoshani.86]

I get "Cannot cast exception"

[alon shoshani.86]

image.png

[Ron S]

You cant cast estimatedAffectEndTime because it is a Column and therefore an Expression.
I think there is no function in exposed that maps adding numbers to sql. So you would need to create one on your own. You need to add the column estimatedAffectEndTime and the intLiteral(60) on sql level