COUNT DISTINCT? - Mailing list pgsql-sql

Folks,

Anybody know a keen shortcut for the following:

SELECT count(skip_date)
FROM (SELECT DISTINCT skip_date FROM weekend_list    WHERE ... ...) days_to_skip;

That's a double aggregate, and is bound to be dog-slow.

--
-Josh BerkusAglio Database SolutionsSan Francisco