ruby-on-rails - ActiveRecord::StatementInvalid Exception: PG::UndefinedFunction: ERROR: function jsonb

首页 > 解决方案 > ActiveRecord::StatementInvalid Exception: PG::UndefinedFunction: ERROR: function jsonb_set(json, unknown, unknown) 不存在

问题描述

我正在使用此查询来更新 jsonb 字段

UPDATE email_lists SET data = jsonb_set(data, '{aa@rr.com}', '{"email":"aa@rr.com","tnc":"1","add_to_list":"1","country_name":"Mexico","added_at":"2018-06-25"}') WHERE id = '50'

但是得到这个错误

ActiveRecord::StatementInvalid Exception: PG::UndefinedFunction: ERROR: function jsonb_set(json, unknown, unknown) 不存在

标签： ruby-on-railspostgresqlactiverecord

ruby-on-rails - ActiveRecord::StatementInvalid Exception: PG::UndefinedFunction: ERROR: function jsonb_set(json, unknown, unknown) 不存在

问题描述

解决方案

推荐阅读