Re: Custom shuffle function stopped working in 9.6

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Custom shuffle function stopped working in 9.6
Date: 2017-02-11 18:51:15
Message-ID: CAADeyWhprxW-rZ4apFuS_j+zzwhpPpQhO0yVMfMZt5KQmrMyXg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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}

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-02-11 19:03:00 Re: Custom shuffle function stopped working in 9.6
Previous Message Alexander Farber 2017-02-11 18:41:21 Re: Custom shuffle function stopped working in 9.6