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
