lele@... wrote:

>>>>>>On Tue, 18 Jun 2002 16:38:02 +0300, Andrew Guts <andr@...> said:
>>>>>>
>>>>>>
>
> AG> Sure, but x.id is a primary key. And 'max(cx.id)' as an
> AG> aggregate function should return only one value or NULL.
>
>Uhm, what does return the following query?
>
> SELECT id, count(*)
> FROM transfers
> GROUP BY id
> HAVING count(*)>1
>
>ciao, lele.
>
>

It rerurn nothing, i.e 0 rows