How to select elements from list in random order
09:08 11 Mar 2026

Character string list contains fixed values

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

known in query creation time. This list should be returned in random order. Tried

select unnest( ARRAY['I','Q','C','K','X','T','S','NE'] )
order by random()

but this returns rows is same order in every run. How to change this so that list or rows appear in random order in each run?

Using Postgres 17

sql postgresql random