From: David G. Johnston <david.g.johnston@gmail.com>
To: Rob Sargent <robjsargent@gmail.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: death of array?
Date: Thu, 6 Apr 2017 20:02:53 -0700
Message-ID: <CAKFQuwZeaKm7xo-bFDSzMbB2=yxHvxeFXAc2vSSmYoVCeuHyZQ@mail.gmail.com> (raw)
In-Reply-To: <73B8E1AF-BD4A-4E6A-B192-8394D59EF47C@gmail.com>
References: <73B8E1AF-BD4A-4E6A-B192-8394D59EF47C@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
On Thu, Apr 6, 2017 at 7:32 PM, Rob Sargent <robjsargent@gmail.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.
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: david.g.johnston@gmail.com, robjsargent@gmail.com
Subject: Re: death of array?
In-Reply-To: <CAKFQuwZeaKm7xo-bFDSzMbB2=yxHvxeFXAc2vSSmYoVCeuHyZQ@mail.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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox