Re: ERROR: for SELECT DISTINCT, ORDER BY expressions

On Wed, 2006-06-07 at 10:09, sergey kapustin wrote:
> Hi all!
> can anybody say me what's wrong with this query. I just try to take
> unique values from table column and print them in random order
>
> select distinct num from (select 1 as num union select 2 as num union
> select 1 as num union select 3) t order by random();
> ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list

You could add another level of sub select here, to put the order by
random() outside the select distinct num. BUT, there's no need for the
distinct. The unions (not union all) guarantee a uniqe return set to
begin with.

Is this the actual query, or a simplified one?

If it's simplified, could we have the original one, and possible
indented in some way so as to make it easier to read?