Monday, September 29, 2008

Re: [GENERAL] Counting unique rows as an aggregate.

On Mon, Sep 29, 2008 at 12:12 PM, r_musta <> wrote:
> However, this is starting to become too slow (as there are about 10 of
> these queries), and therefore I need to write an aggregate function
> which lets me do:
>>SELECT count_unique(make), count_unique(color) from table WHERE >criteria<;
> After reading about aggregate functions, this should be possible, as
> long as I can use a dictionary/hashmap type for the state<STYPE>
> argument.

This might be a nice fit for materialized views. While they're not
built in, PostgreSQL's extensibility allows you to build them prettily

Jonathan Gardner's web page on it is fantastic.

Sent via pgsql-general mailing list (
To make changes to your subscription:

No comments: