How to select elements from list in random order
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