Re: About sorting rows randomly

From: Ian Barwick <ian(at)barwick(dot)de>
To: "Marc Soler" <msoler(at)el-valles(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: About sorting rows randomly
Date: 2003-03-28 12:01:16
Message-ID: 200303281301.16271.ian@barwick.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Friday 28 March 2003 09:32, Marc Soler wrote:
> Hi all
>
> It's possible to return rows randomly sorted?
>
> Something like this:
>
> Select * from table order by random

SELECT foo, bar, random() AS rand FROM my_table ORDER BY rand

Ian Barwick
barwick(at)gmx(dot)net

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message lists 2003-03-28 12:35:44 pg_restore problem
Previous Message Tatiana Motova 2003-03-28 11:50:36 Re: pg_dump problem