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 | dsafsdfcde | sdfdsf
(2 rows)
Hans