Many thanks both, those solutions are great and have gone in my wiki for future ref. Regards Oliver
On 21 Sep 2011, at 21:56, Szymon Guz wrote: > > > >> Short answer is: yes. More information you can find > >> here > >> http://simononsoftware.com/problem-with-random-in-postgresql-subselect/ > >> regards > >> Szymon > >> > >