agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Rob Sargent <robjsargent@gmail.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: death of array?
Date: Fri, 7 Apr 2017 09:57:22 -0600
Message-ID: <d1ce18b8-c5cb-9547-c0b3-8a4910f96483@gmail.com> (raw)
In-Reply-To: <CAKFQuwbiU4viib21wWKa3T_4w343MioOjeqxkeeRYkMD5hqsfA@mail.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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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.
view thread (11+ messages) latest in thread
Message-ID: <d1ce18b8-c5cb-9547-c0b3-8a4910f96483@gmail.com>
Permalink: ../d1ce18b8-c5cb-9547-c0b3-8a4910f96483@gmail.com/
Also on: postgresql.org/message-id/d1ce18b8-c5cb-9547-c0b3-8a4910f96483@gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: robjsargent@gmail.com, david.g.johnston@gmail.com
Subject: Re: death of array?
In-Reply-To: <d1ce18b8-c5cb-9547-c0b3-8a4910f96483@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox