Re: question about a select - Mailing list pgsql-general

On Thu, 9 Oct 2003, Cindy wrote:


> Text=# select distinct on (y_level) y_level, byteloc from
> citations_by_level where aid=543 and wid=1 order by byteloc;
> ERROR:  SELECT DISTINCT ON expressions must match initial ORDER BY
> expressions

Maybe something like:

select y_level from (select distinct on (y_level) y_level,
byteloc from citations_by_level where aid=543 and wid=1) tab order by
byteloc;