From: "Mark Williams" <markwillimas@gmail.com>
To: "'David G. Johnston'" <david.g.johnston@gmail.com>
Cc: "'Rob Sargent'" <robjsargent@gmail.com>,
	"'pgsql-sql'" <pgsql-sql@lists.postgresql.org>
References: <004301d485bc$00347250$009d56f0$@gmail.com>
 <57AC3D96-24B8-4D06-8946-AF6E0116888F@gmail.com>
 <004e01d485c2$6c45cb50$44d161f0$@gmail.com>
 <CAKFQuwa6=d3_BuGQd8sq44bvO0922VNTZGgdk8h_JTaEcpNSYQ@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwa6=d3_BuGQd8sq44bvO0922VNTZGgdk8h_JTaEcpNSYQ@mail.gmail.com>
Subject: RE: Select Distinct Order By Array_Position
Date: Mon, 26 Nov 2018 20:22:28 -0000
Message-ID: <005601d485c5$c1303300$43909900$@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQEpSAIENSM0BdolJjQVlTJ5xV69VAHbwdfGAoJzNWYBsEj4LKaIh2wQ
Content-Language: en-gb
Precedence: bulk

Many thanks. I'll mess around with what you've sent and see if I can get =
it working.

__

-----Original Message-----
From: David G. Johnston <david.g.johnston@gmail.com>=20
Sent: 26 November 2018 20:07
To: Mark Williams <markwillimas@gmail.com>
Cc: Rob Sargent <robjsargent@gmail.com>; pgsql-sql =
<pgsql-sql@lists.postgresql.org>
Subject: Re: Select Distinct Order By Array_Position

On Mon, Nov 26, 2018 at 12:58 PM Mark Williams <markwillimas@gmail.com> =
wrote:
>
> Wasn=E2=80=99t aware it was possible to put array_position statement =
in the actual select or is this a select within a select?

Easy enough to try either way

> Also, I am selecting from an ordered (randomly) subset of data and I =
need to return the result set in the same order so do have to output the =
array as part of the order by?

Not sure what the question is...

Anyway, maybe this will be helpful:

SELECT vals.*
FROM (VALUES (1::integer),(2),(3),(4),(5)) vals (v), LATERAL =
unnest(ARRAY[3,1,5]::integer[]) with ordinality AS spec (s, o) WHERE v =
=3D s ORDER BY o

David J.