Postgres Pro
Downloads
Home   >   mailing lists

Re: About sorting rows randomly - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: About sorting rows randomly
Date
Msg-id Pine.LNX.4.44.0303281447430.2204-100000@peter.localdomain
Whole thread Raw
In response to About sorting rows randomly  ("Marc Soler" <msoler@el-valles.com>)
List pgsql-admin
Tree view 
Marc Soler writes:

> It's possible to return rows randomly sorted?

select * from table order by random();

--
Peter Eisentraut   peter_e@gmx.net

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [ Possible problem with Postgres ]
Next
From: "A.M."
Date:
Subject: Realistic upper bounds on table size