Horton

Re: [PATCH] Introduce array_shuffle() and array_sample()

Gregory Stark (as CFM) <stark.cfm@gmail.com>

View thread View on postgr.es
From: "Gregory Stark (as CFM)" <stark.cfm@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Martin Kalcher <martin.kalcher@aboutsource.net>, Fabien COELHO <coelho@cri.ensmp.fr>, Andres Freund <andres@anarazel.de>, Dean Rasheed <dean.a.rasheed@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Andrew Dunstan <andrew@dunslane.net>, John Naylor <john.naylor@enterprisedb.com>, Thomas Munro <thomas.munro@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-03-20T19:34:55Z
Lists: pgsql-hackers, pgsql-general 
On Thu, 29 Sept 2022 at 15:34, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Martin Kalcher <martin.kalcher@aboutsource.net> writes:
> > New patch: array_shuffle() and array_sample() use pg_global_prng_state now.
>
> I took a closer look at the patch today.  I find this behavior a bit
> surprising:
>

It looks like this patch received useful feedback and it wouldn't take
much to push it over the line. But it's been Waiting On Author since
last September.

Martin, any chance of getting these last bits of feedback resolved so
it can be Ready for Commit?

-- 
Gregory Stark
As Commitfest Manager

Commits

  1. Add array_sample() and array_shuffle() functions.

  2. Use a separate random seed for SQL random()/setseed() functions.