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
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.