How to interpolate a list of UUIDs into a raw sql query?

Questions / Help
,
1

My query is:

Ecto.Adapters.SQL.query(
Some.Repo,
"Some Query...
  WHERE
         place_id IN $1
         GROUP BY place_id",
      [place_ids]
)

This gives me "syntax error at or near \"$1\""

2

IN syntax requires literal (). You probably want to do what Ecto does and do it as place_id = ANY($1).

2 Likes