Re: order by rand()

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