ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in target list
all i want to do is select distinct names and order them ignoring case...
specific code:
select distinct author from news order by upper(author);
that gives me the error above. how do i get around this?
