Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Custom shuffle function stopped working in 9.6 - Mailing list pgsql-general

From Alexander Farber
Subject Re: [GENERAL] Custom shuffle function stopped working in 9.6
Date
Msg-id CAADeyWhprxW-rZ4apFuS_j+zzwhpPpQhO0yVMfMZt5KQmrMyXg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Custom shuffle function stopped working in 9.6  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: [GENERAL] Custom shuffle function stopped working in 9.6  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: [GENERAL] Custom shuffle function stopped working in 9.6  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
At the same time this advice from
http://stackoverflow.com/questions/42179012/how-to-shuffle-array-in-postgresql-9-6-and-also-lower-versions
works, don't know why though:

words=> select array_agg(u order by random())
words-> from unnest(array['a','b','c','d','e','f']) u;
   array_agg   
---------------
 {d,a,f,c,b,e}

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: [GENERAL] Custom shuffle function stopped working in 9.6
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Custom shuffle function stopped working in 9.6