Wed Jun 07 08:40:48 GMT 2006 Order-by side effectDo not use ORDER BY if the query has a DISTINCT or GROUP BY on the same set of terms, because they have the side effect of ordering rows http://archives.postgresql.org/pgsql-general/2004-12/msg01340.php (google search) (amazon search) second |