I want a "dirty" solution try something like that. If you use "group by
author" url must be in aggregate function. The authors are now DISTINCT.
myjava=# SELECT author, max(url) FROM books group by author;
author | max
--------+---------
abc | dsafsdf
cde | sdfdsf
(2 rows)
Hans