PostgreSQL 16: SELECT returns rows but UPDATE with the same WHERE clause finds none
I am encountering an issue in PostgreSQL 16 where a SELECT query returns 4 rows, but using the same WHERE clause in an UPDATE statement results in no rows being found.