On 2019-07-23 17:43, Cyril Champier wrote: > In this documentation > <https://www.postgresql.org/docs/9.1/queries-order.html>, it is said: > > If sorting is not chosen, the rows will be returned in an > unspecified order. The actual order in that case will depend on the > scan and join plan types and the order on disk, but it must not be > relied on. > > > I would like to know if there is any way to change that to have a "real" > random behaviour.
It might be an interesting exercise to implement this as a post-parsing hook. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
