Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select setseed(.42);--this re-sets `random()` but not `array_shuffle()`
select random();
select unnest(array_shuffle(array['I','Q','C','K','X','T','S','NE'])); 

setseed

SELECT 1

random

0.742944875302392

SELECT 1

unnest

I

S

K

C

Q

T

NE

X

SELECT 8

select array_sample(array['I','Q','C','K','X','T','S','NE'],4);

select (array_shuffle(array['I','Q','C','K','X','T','S','NE']))[:4];

array_sample

{S,X,C,T}

SELECT 1

array_shuffle

{Q,X,S,NE}

SELECT 1

select setseed(.42);--this re-sets `random()` but not `array_shuffle()`
select random();
select unnest(array_shuffle(array['I','Q','C','K','X','T','S','NE'])); 

setseed

SELECT 1

random

0.742944875302392

SELECT 1

unnest

Q

NE

X

T

I

C

K

S

SELECT 8

-- Source - https://stackoverflow.com/q/79905400
-- Posted by Andrus, modified by community. See post 'Timeline' for change history
-- Retrieved 2026-03-11, License - CC BY-SA 4.0
begin;

create temp table test ( test text );
insert into test values (null);
insert into test values (null);

update test set
 test= 
 
(SELECT string_agg(val,',' order by random())
FROM (
    SELECT unnest(ARRAY['I','Q','C','K','X','T','S','NE']) AS val
) t
ORDER BY random()) 
returning test;

rollback;

BEGIN

CREATE TABLE

INSERT 0 1

INSERT 0 1

test

C,K,X,I,S,T,NE,Q

C,K,X,I,S,T,NE,Q

UPDATE 2

ROLLBACK

-- Source - https://stackoverflow.com/q/79905400
-- Posted by Andrus, modified by community. See post 'Timeline' for change history
-- Retrieved 2026-03-11, License - CC BY-SA 4.0

create temp table test(test) as values
  (null::text)
 ,(null);

update test
set test=array_to_string(array_shuffle(ARRAY['I','Q','C','K','X','T','S','NE']),',')
returning test;

SELECT 2

test

T,X,NE,I,K,Q,S,C

I,NE,X,S,T,K,C,Q

UPDATE 2