PostgreSQL query error

The following error occurs when using with PostgreSQL

warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /var/web/users/netalfaweb/web2.netalfa.hu/webdata/includes/database.pgsql.inc on line 139.
user warning: query: SELECT DISTINCT nc.nid FROM node_comment_statistics nc INNER JOIN node_access na ON na.nid = nc.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner'))) AND ( nc.comment_count > 0 )ORDER BY nc.last_comment_timestamp DESC LIMIT 10 OFFSET 0 in /var/web/users/netalfaweb/web2.netalfa.hu/webdata/modules/comment/comment.module on line 314.

The corrected line:

$result = db_query_range(db_rewrite_sql("SELECT nc.nid, nc.last_comment_timestamp FROM {node_comment_statistics} nc WHERE n c.comment_count > 0 ORDER BY nc.last_comment_timestamp DESC", 'nc'), 0, $number);