Postgres Pro
Downloads
Home   >   mailing lists

Re: Distinct Values - Mailing list pgsql-sql

From Hans-Jürgen Schönig
Subject Re: Distinct Values
Date
Msg-id 3B1CA478.B91CBEED@cybertec.at
Whole thread Raw
In response to Distinct Values  ("Nicolas" <bnk@medialife.net>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Nils Zonneveld
Date:
Subject: Re: php-nuke
Next
From: mikael.kjellstrom@_no_spam_flygtaxi.se (Mikael Kjellström)
Date:
Subject: Foreign key to base table with rows in inherited tables