Re: [GENERAL] Custom shuffle function stopped working in 9.6

On 02/11/2017 09:17 AM, Alexander Farber wrote:
> I think ORDER BY RANDOM() has stopped working in 9.6.2:
>
> words=> select unnest(ARRAY['a','b','c','d','e','f']) order by random();
>  unnest
> --------
>  a
>  b
>  c
>  d
>  e
>  f
> (6 rows)
>

postgres=> select version();
                                       version
-------------------------------------------------------------------------------------
 PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (SUSE Linux) 4.8.5, 64-bit
(1 row)

postgres=> select * from  unnest(ARRAY['a','b','c','d','e','f']) order by random();
 unnest
--------
 d
 c
 a
 f
 e
 b
(6 rows)

postgres=> select * from  unnest(ARRAY['a','b','c','d','e','f']) order by random();
 unnest
--------
 b
 d
 e
 c
 a
 f
(6 rows)



--
Adrian Klaver
adrian.klaver@aklaver.com