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

I am using Slick 2.1.0 and PostgreSQL 9.x.

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

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

      

This code doesn't work (can't resolve 'in' character):

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

      

+3


source to share


1 answer


Not. There is a mailing discussion discussion about how to emulate it: https://groups.google.com/d/msgid/scalaquery/6bbc7e19-07d2-43fb-b378-7db82ca78664%40googlegroups.com



Feature request here: https://github.com/slick/slick/issues/517

+2


source







All Articles