[SQL] Re: Distinct Values

[Hans-Jürgen Schönig]

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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])