PgSQL 7.4 SQL syntax

with UR with pgsql 7.4 i got sql error messages about GROUP BY

sorry, i'm not familiar with module patches, i will write the code that helped me here:

if variable $selects value is "DISTINCT ur.rid,ur.*,urt.*":
GROUP BY rid,ur.requester_id,ur.requestee_id,ur.rtid,ur.approved,ur.created_at,ur.updated_at,ur.flags,urt.rtid,urt.name,urt.plural_name,urt.is_oneway,urt.requires_approval,urt.expires_val

other cases:
GROUP BY rid,,ur.requester_id,ur.requestee_id,ur.rtid,ur.approved,ur.created_at,ur.updated_at,ur.flags,urt.rtid,urt.name,urt.plural_name,urt.is_oneway,urt.requires_approval,urt.expires_val,requesters.name,requestees.name,requesters.mail,requestees.mail,requesters.data,requestees.data,requesters.picture,requestees.picture

apparently .picture is only if userpic module is available