Conditionally update multiple columns with same CASE subquery Currently using PostgreSQL 16.4. I looked at this post but it didn’t cover my use case.