Thread: order by rand()

I'm wondering if postgress is able to do order by rand() or if it is done by
some other means through php easily


Mike Sears
Web Developer
http://www.vianet.ca

Mike Sears writes:

> I'm wondering if postgress is able to do order by rand() or if it is done by
> some other means through php easily

The function is called random(), but yes, it works.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

At 23:46 18/07/00 +0200, Peter Eisentraut wrote:
>Mike Sears writes:
>
>> I'm wondering if postgress is able to do order by rand() or if it is
done by
>> some other means through php easily
>
>The function is called random(), but yes, it works.
>
Is this a 7.x only feature ?

With 6.5.2 I get

select * from topten where room='SM' order by random();
ERROR:  No such function 'random' with the specified attributes
--
thorNET  - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax:   01454 854412
http://www.thornet.co.uk