Re: Random sort with distinct

What about dynamic queries?

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

Hey Ozer,

How about dynamic queries?

2010/10/2 Ozer, Pam <pozer(at)automotive(dot)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.