Re: [SQL] death of array?

On 04/07/2017 09:26 AM, David G. Johnston wrote:

On Fri, Apr 7, 2017 at 8:22 AM, Rob Sargent <robjsargent@gmail.com> wrote:

Thank you both for your suggestions, but does either apply to joining through the array in a flow of join operations?  Or must I do the work on the array in the where clause?

​field = any(array_col) works anywhere ...​

​David J.

​

Understood but  true if any match is found, I need every array member to match as I want them all to be of a specific people as input into the query (so field = all(array_col))  and "field" here would be people_member.person_id and using that yields zero results in full query (very quickly though).

But my understanding of the documentation of ALL is debatable.  What does "the left-hand expression is evaluated" yield for people_member.person_id? The where clause would restrict it to one people_id but thats still more that what's in probandset.probands.