Re: [PATCH] Introduce array_shuffle() and array_sample() - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: [PATCH] Introduce array_shuffle() and array_sample()
Date
Msg-id CAKFQuwZ9o3Nw5TVgPf9xeTc73ad=BYJjT9werq6ztp6Lb_FVHA@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Introduce array_shuffle() and array_sample()  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCH] Introduce array_shuffle() and array_sample()
List pgsql-hackers
On Mon, Jul 18, 2022 at 3:18 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:

Independently of the dimensionality question --- I'd imagined that
array_sample would select a random subset of the array elements
but keep their order intact.  If you want the behavior shown
above, you can do array_shuffle(array_sample(...)).  But if we
randomize it, and that's not what the user wanted, she has no
recourse.


And for those that want to know in what order those elements were chosen they have no recourse in the other setup.

I really think this function needs to grow an algorithm argument that can be used to specify stuff like ordering, replacement/without-replacement, etc...just some enums separated by commas that can be added to the call.

David J.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] Introduce array_shuffle() and array_sample()
Next
From: Justin Pryzby
Date:
Subject: Re: Commitfest Update