Horton

Re: Proposal to introduce a shuffle function to intarray extension

John Naylor <john.naylor@enterprisedb.com>

View thread View on postgr.es
From: John Naylor <john.naylor@enterprisedb.com>
To: Martin Kalcher <martin.kalcher@aboutsource.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Thomas Munro <thomas.munro@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-07-18T08:18:44Z
Lists: pgsql-hackers, pgsql-general 
On Mon, Jul 18, 2022 at 2:47 PM Martin Kalcher <
martin.kalcher@aboutsource.net> wrote:
> One more question. How do i pick a Oid for the functions?

For this, we recommend running src/include/catalog/unused_oids, and it will
give you a random range to pick from. That reduces the chance of different
patches conflicting with each other. It doesn't really matter what the oid
here is, since at feature freeze a committer will change them anyway.

--
John Naylor
EDB: http://www.enterprisedb.com

Commits

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

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