On Mon, Sep 29, 2008 at 12:12 PM, r_musta <[EMAIL PROTECTED]> 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 easily. http://jonathangardner.net/tech/w/PostgreSQL/Materialized_Views Jonathan Gardner's web page on it is fantastic. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
