|
-- DANGER! With non-unique values, you get more rows than an IN clause would return
select *
from links l
inner join (
values (1,2,3,4),(1,2,5,4),(1,2,5,4)
) v(id1, id2, id3, id4) using(id1, id2, id3, id4);
id1 |
id2 |
id3 |
id4 |
content |
1 |
2 |
3 |
4 |
Text |
1 |
2 |
5 |
4 |
Other thing |
1 |
2 |
5 |
4 |
Other thing |
… |
|