| From: | Steve Heaven <steve(at)thornet(dot)co(dot)uk> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Mike Sears <matrix(at)vianet(dot)ca> |
| Cc: | Psql List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: order by rand() |
| Date: | 2000-07-19 08:08:28 |
| Message-ID: | 3.0.1.32.20000719090828.00b40350@mail.thornet.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Janík ml. | 2000-07-19 09:11:05 | Re: pg_dump with BLOBS & V7.0.2 UPDATED |
| Previous Message | Gilles DAROLD | 2000-07-19 07:44:16 | Re: cursor problem |