Random sort with distinct - Mailing list pgsql-sql

From Ozer, Pam
Subject Random sort with distinct
Date
Msg-id 216FFB77CBFAEE4B8EE4DF0A939FF1D10182C8@mail-001.corp.automotive.com
Whole thread Raw
Responses Re: Random sort with distinct  (Dmitriy Igrishin <dmitigr@gmail.com>)
Re: Random sort with distinct  (Lee Hachadoorian <lee.hachadoorian@gmail.com>)
Re: Random sort with distinct  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
<div class="WordSection1"><p class="MsoNormal">I have the following query<p class="MsoNormal"> <p
class="MsoNormal">SelectDistinct VehicleMake, VehicleModel<p class="MsoNormal">From VehicleYearMakeModelTrim<p
class="MsoNormal">Orderby random()<p class="MsoNormal">Limit 10;<p class="MsoNormal"> <p class="MsoNormal">I don’t want
tobring back the random number I just want the sort order to be random. How can I sort randomly?  This query breaks
becauserandom() is not in the select.<p class="MsoNormal"> <p class="MsoNormal">Thanks<p class="MsoNormal"> <p
class="MsoNormal">Pam<pclass="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><br /><br
/></span></div>

pgsql-sql by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: Question about PQexecParams
Next
From: Dmitriy Igrishin
Date:
Subject: Re: Random sort with distinct