COUNT DISTINCT?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: COUNT DISTINCT?
Date: 2002-07-30 21:27:18
Message-ID: 200207301427.18815.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Berkus
Aglio Database Solutions
San Francisco

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-07-30 21:45:16 Re: COUNT DISTINCT?
Previous Message Stephan Szabo 2002-07-30 19:23:30 Re: Delete a FOREIGN KEY