On Thu, Apr 6, 2017 at 7:32 PM, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
> 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)
WHERE v = ANY(i)
);
// 2
HTH
David J.