Subject: Re: death of array?
To: "David G. Johnston" <david.g.johnston@gmail.com>
References: <73B8E1AF-BD4A-4E6A-B192-8394D59EF47C@gmail.com>
 <CAKFQuwZeaKm7xo-bFDSzMbB2=yxHvxeFXAc2vSSmYoVCeuHyZQ@mail.gmail.com>
 <58E7319B.9090306@matrix.gatewaynet.com>
 <5fef6cfe-a47f-4276-f95f-259fb661276a@gmail.com>
 <CAKFQuwbiU4viib21wWKa3T_4w343MioOjeqxkeeRYkMD5hqsfA@mail.gmail.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: Rob Sargent <robjsargent@gmail.com>
Message-ID: <d1ce18b8-c5cb-9547-c0b3-8a4910f96483@gmail.com>
Date: Fri, 7 Apr 2017 09:57:22 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.4.0
MIME-Version: 1.0
In-Reply-To: 
 <CAKFQuwbiU4viib21wWKa3T_4w343MioOjeqxkeeRYkMD5hqsfA@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------3BF35BB4BAB7E5F9E23BA24F"
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

This is a multi-part message in MIME format.
--------------3BF35BB4BAB7E5F9E23BA24F
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

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 
> <mailto: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.

--------------3BF35BB4BAB7E5F9E23BA24F
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    On 04/07/2017 09:26 AM, David G. Johnston wrote:<br>
    <blockquote
cite="mid:CAKFQuwbiU4viib21wWKa3T_4w343MioOjeqxkeeRYkMD5hqsfA@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div class="gmail_default"
          style="font-family:arial,helvetica,sans-serif"><span
            style="font-family:arial,sans-serif">On Fri, Apr 7, 2017 at
            8:22 AM, Rob Sargent </span><span dir="ltr"
            style="font-family:arial,sans-serif">&lt;<a
              moz-do-not-send="true" href="mailto:robjsargent@gmail.com"
              target="_blank">robjsargent@gmail.com</a>&gt;</span><span
            style="font-family:arial,sans-serif"> wrote:</span></div>
        <div class="gmail_extra">
          <div class="gmail_quote">
            <blockquote class="gmail_quote" style="margin:0 0 0
              .8ex;border-left:1px #ccc solid;padding-left:1ex">
              <div bgcolor="#FFFFFF" text="#000000">
                <div>
                  <div class="h5">
                    <blockquote type="cite"> </blockquote>
                  </div>
                </div>
                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? <br>
              </div>
            </blockquote>
            <div><br>
            </div>
            <div>
              <div class="gmail_default"
                style="font-family:arial,helvetica,sans-serif">​field =
                any(array_col) works anywhere ...​</div>
            </div>
          </div>
          <br>
        </div>
        <div class="gmail_extra">
          <div class="gmail_default"
            style="font-family:arial,helvetica,sans-serif">​David J.</div>
          <div class="gmail_default"
            style="font-family:arial,helvetica,sans-serif">​</div>
          <br>
        </div>
      </div>
    </blockquote>
    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).<br>
    <br>
    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. <span
      style="color: rgb(0, 0, 0); font-family: verdana, sans-serif;
      font-size: 12.16px; font-style: normal; font-variant-ligatures:
      normal; font-variant-caps: normal; font-weight: normal;
      letter-spacing: normal; orphans: 2; text-align: left; text-indent:
      0px; text-transform: none; white-space: normal; widows: 2;
      word-spacing: 0px; -webkit-text-stroke-width: 0px;
      background-color: rgb(255, 255, 255); display: inline !important;
      float: none;"><br>
    </span>
  </body>
</html>

--------------3BF35BB4BAB7E5F9E23BA24F--