Hi all!
any suggestion how to run this kind of query in postgresql with expose?
Copy code
UPDATE events_affecting_transit
SET estimated_affect_end_time = estimated_affect_end_time + interval '5 hour'
WHERE current_timestamp > estimated_affect_end_time
when I'm trying do like that,
I get "Cannot cast exception"
image.png
r
Ron S
04/24/2022, 3:32 PM
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