On 1/5/22 14:36, Shaozhong SHI wrote:
I just checked operators. I could not find any operator to set a new value given a key.
I'd say jsonb_set is what you're looking for.Postgres does not have a thing that'd match the Oracle feature exactly, you'll have to adjust your application to use what's available.
regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
