Toggle boolean value inside query

Hello,

I’m trying to toggle boolean value in database query, not with IF-ELSE logic in Server action.
Toggle means if value is true - set to false, and vice versa.

So my DB server is PostgreSQL and with query it quite simple: for instance boolean fields calls seen query will be quite simple: UPDATE table SET seen = NOT seen WHERE id = :id

And question is: it’s possible to achieve same but with data bindings or conditions?

image1210×1031 48.9 KB