How to run a SELECT WHERE column IN (...) query?

[OvermindDL1]

@francois

Note that the above query is not even the same query I wrote originally. I used NOT IN, but this query is IN. I have to find how to do a NOT IN now.

not users.slug in ^user_slugs_who_are_present, the not is a unary function, the inis a binary function, thus the precedence is likenot(users.slug in ^user_slugs_who_are_present)`.

I think a future-elixir version is going to allow not in as a binary function though, I think…

@francois

This fails because room_id is a string, but the database type is a UUID.

Strings are not UUID’s. Something like "afe13f89-7819-43d9-9bb8-b4ba38a2ddac" is not a UUID but is a string. A UUID is 16 bytes of binary. The "afe13f89-7819-43d9-9bb8-b4ba38a2ddac" is a common human-readable representation but you should never ever ever pass around UUID’s in the human readable representation and should keep them as what they are, 16-byte binaries (in my humble opinion ^.^). However yes, you need to cast it with I think it is Ecto.UUID.cast, not :uuid.