Error with postgresql (GROUP BY)

What does MAX(ip_address) address for?
No? In fact, I don't understand the meaning of this SQL query.
Could you explain what it does ?

In user_stats.module, this is this line:

$query = db_query("SELECT MAX(ip_address)
        FROM {user_stats_ips} WHERE uid = %d
        ORDER BY first_seen_timestamp", $uid);

I think the SQL command **could be*** wrong in both MySQL and PostgreSQL.

The SQL command is trying to select the fist row. This should be:

$query = db_query("SELECT ip_address
        FROM {user_stats_ips} WHERE uid = %d
        ORDER BY first_seen_timestamp LIMIT 1", $uid);

Status patch reviewed by the community.

$query = db_query("SELECT ip_address
        FROM {user_stats_ips} WHERE uid = %d
        ORDER BY first_seen_timestamp LIMIT 1", $uid);

The original query may be wrong, we are not trying to select the maximum value of an IP, but the first row.

I ran into this as well. The GROUP BY problem is typical in PostgreSQL since MySQL conveniently ignores what is normally bad logic when GROUP BYs are involved.

I too however was wondering what the rationale for the MAX(ip_address) call was. It seems to me that the desired behavior is to return the most recently used IP address which as others above have pointed out can be done with an ORDER BY and LIMIT.

Fixed. Thanks. :)