Does Slick support methods 'inSet' or 'in' for tuples?

Question

I'm using Slick 2.1.0 and PostgreSQL 9.x.

How can I make this SQL (correct for postgresql) using Slick lifted query:

select * from someObjects 
            where (key, value) in (('k1', 'value1'), ('k2', 'value2'));

This code is not works (can't resolve symbol 'in'):

someObjects.filter { o => 
    (o.key, o.value) in (("k1", "value1"), ("k2", "value2")) 
}

score 4 · Accepted Answer · answered Sep 10 '14 at 14:40

4

answered Sep 10 '14 at 14:40

cvogt

1 Answers1