Re: About sorting rows randomly

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Marc Soler <msoler(at)el-valles(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: About sorting rows randomly
Date: 2003-03-28 13:56:35
Message-ID: Pine.LNX.4.44.0303281447430.2204-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Marc Soler writes:

> It's possible to return rows randomly sorted?

select * from table order by random();

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message A.M. 2003-03-28 17:07:54 Realistic upper bounds on table size
Previous Message Peter Eisentraut 2003-03-28 13:55:21 Re: [ Possible problem with Postgres ]