And this doesn't: select count(distinct id) from bg order by id; ERROR: column "bg.id <http://bg.id>" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: select count(distinct id) from bg order by id;
Your result set will contain one row with the count of distinct ids. You can't really order 1 row.
The error message occurs because your result set has one unnamed column: count(distinct id). You could write the query like:
select count(distinct id) as cnt from bg order by cnt; That would be correct SQL, because the column "cnt" now does exist. Kind regards, Andomar -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
