order by rand()

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