I need to gather all segments whose probandset is within in a specified people. select s.* from segment s join probandset ps on s.probandset_id = ps.id --PROBLEM: WOULD LIKE SOMETHING BETTER THAN THE FOLLOWING:
SELECT s.* implies semi-joins - so lets see how that would work.
SELECT vals.*
FROM ( VALUES (2),(4) ) vals (v)
WHERE EXISTS (
SELECT 1 FROM ( VALUES (ARRAY[1,2,3]::integer[]) ) eyes (i)