Hi all, any suggestion how to run this kind of query in postgresql with expose? ```UPDATE events_aff...

# server

[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"

[Ties]

No experience with exposed. But I would guess "estematedEffecttime as instant" gives you the error, since it's not actually an instant but a column

[alon shoshani.86]

@Ties already tried, it says can cast estematedEffecttime as instant