Category: Data Source
Updated

This solution is summarized from an archived support forum post. This information may have changed. If you notice an error, please let us know in Discord.

Postgres query returns invalid input syntax while updating jsonb column fields

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.