Issue
I was trying to update fields of a jsonb column with a Postgres query, but I kept getting an error for invalid input syntax. However, a similar query worked on my local Postgres client. Turning off the smart-substitution setting resolved the error.
Resolution
The issue was with updating fields of a JSONB column with a PostgreSQL query that was giving an error for invalid input syntax. The solution was to turn off the "smart-substitution" setting. This resolved the issue and the query worked successfully.
No code examples were provided.