Home > mailing lists

limitby without orderby - Mailing list pgsql-general

From	Rohan Malhotra
Subject	limitby without orderby
Date	September 22, 2011 08:32:40
Msg-id	CAEoM48VWWmaTUf9JihdYAvOO+gt8M_TydMErdTGaXfhOfa=M=Q@mail.gmail.com Whole thread Raw
Responses	Re: limitby without orderby Re: limitby without orderby
List	pgsql-general

Hi Gurus,

What is difference between

select * from items order by random() limit 5;

and

select * items limit 5;

my basic requirement is to get random rows from a table, my where clause will make sure I won't get same rows in repeated execution of above queries.

Regards

From: Rafal Pietrak
Date: 22 September 2011, 08:05:29
Subject: why VOLATILE attribute is required?

From: Oliver Kohll - Mailing Lists
Date: 22 September 2011, 08:43:40
Subject: Re: Random multiple times