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
> >>
> >