This is the first time I am submitting a question so be gentle
I am trying to query a string value in a jsonb col with an Ecto fragment and see weather it is in an array of strings.
The psql which works looks something like this:
SELECT * FROM someTable WHERE someCol->'someKey' <@ '["AString", "AnotherString"]'
My fragment that I am trying to create looks like:
fragment("(?->>'someKey' <@ ?", u.someCol, ^myArrayOfStrings))
which is throwing a syntax error
Postgrex.Error) ERROR 42601 (syntax_error) syntax error at end of input
Thanks in advance for any assistance.