数字数组查询不对劲

Question

liyuan1125 opened this issue 2 years ago · 2 comments

数据是这样的

["330100", "330200", "330300", "330400", "330500", "330600", "330700", "330800", "330900", "331000", "331100"]

db.Table("table_name").Where(datatypes.JSONQuery("area_code").HasKey("330100")).Find(&rows)

错误：

Invalid JSON path expression. The error is around character position 8.

Answer 1 · 2023-02-09T09:37:51.000Z

可以试试这么查询，db.Table("table_name").Where(datatypes.JSONArrayQuery("area_code").Contains("330100")).Find(&rows)

Answer 2 · 2023-09-20T06:46:02.000Z

same problem
how to query this in postgresql ?

select * from table where area_code::jsonb @>'[330100]'