Postgres Pro
Downloads
Home   >   mailing lists

Re: Random sort with distinct - Mailing list pgsql-sql

From Ozer, Pam
Subject Re: Random sort with distinct
Date
Msg-id 216FFB77CBFAEE4B8EE4DF0A939FF1D10182D0@mail-001.corp.automotive.com
Whole thread Raw
In response to Re: Random sort with distinct  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-sql
Tree view

What about dynamic queries?

 

From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Dmitriy Igrishin
Sent: Saturday, October 02, 2010 6:40 AM
To: Ozer, Pam
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Random sort with distinct

 

Hey Ozer,

How about dynamic queries?

2010/10/2 Ozer, Pam <pozer@automotive.com>

I have the following query

 

Select Distinct VehicleMake, VehicleModel

From VehicleYearMakeModelTrim

Order by random()

Limit 10;

 

I don’t want to bring back the random number I just want the sort order to be random. How can I sort randomly?  This query breaks because random() is not in the select.

 

Thanks

 

Pam

 




--
// Dmitriy.

pgsql-sql by date:

Previous
From: Joshua Tolley
Date:
Subject: Re: join returns too many results...
Next
From: Andreas Forø Tollefsen
Date:
Subject: Create Datefield from 3 fields