JSONArrayContains returns SQL + the arg to check if a JSON array column contains a given text value, compared exactly (case and all). SQLite: a json_each element of type text equal to the arg, on a valid JSON array (a malformed row matches nothing rather than erroring). PostgreSQL: "column::jsonb @>
(column, value string)
| 142 | // Postgres built the JSON by hand, so a quote made invalid JSON and |
| 143 | // `a","b` asked for two elements. |
| 144 | JSONArrayContains(column, value string) (string, interface{}) |
| 145 | |
| 146 | // JSONArrayElements returns a FROM-clause table-function fragment that |
| 147 | // unnests a JSON text-array column into one row per element, plus the |
no outgoing calls
no test coverage detected